When you replace formulas with their values Excel permanently removes the formulas. Based on certain values in our worksheet we might decide to format the sheet by assigning colors based on values. I tried it with an IF-statement.
Click on Conditional Formatting.
We will also learn how to use Excel formulas to change the background colors of cells with formula errors or blank cells. Paste Values with a Simple Keyboard Shortcut. When the formula is applied to the cells on the bottom only row references change for reference F6. Use Excel formula to change background color of special cells A cells color will change automatically based on the cells value.