Excel Formula Color Cell If Value. Launch excel and open a spreadsheet. 2 2 if you want to shade cell a1 when value of b4 is greater than 500 then enter formula b4 500 into the format values where this formula is true box.
If d4 c4 overdue ontime this formula can be copied down to row 12. Then enter one of the following formulas in the format values where this formula is true field. A cell can be formatted by conditional formatting based on the value returned by an if statement on your excel worksheet.
Now select use a formula to determine which cells to format option and in the box type the formula.
Highlight one or more cells in a column and click conditional formatting in the styles section of the home tab on the ribbon. Then select format button to select green as the fill color. Now we will select the last option use a formula to determine which cells to format we need to set up a formatting formula so that it returns a true or false value. Unique or duplicate values.
