- Select the cell that you want to apply the conditional formatting to.
- Go to the Home tab in the ribbon and click on Conditional Formatting in the Styles group.
- Select New Rule from the drop-down menu.
- In the New Formatting Rule dialog box, select Use a formula to determine which cells to format.
- In the Format values where this formula is true field, enter your formula. For example, if you want the cell to turn black if A6 is greater than 1, enter the formula .
- Click on the Format button to choose the formatting you want to apply to the cell. In this case, you want to change the font color to black, so select the Font tab and choose black from the color palette.
- Click OK to close the Format Cells dialog box.
- Click OK again to close the New Formatting Rule dialog box.
Now, when the
formula evaluates to true, the cell will turn black. If you want the cell to display the word "black" as well, you can modify your formula to include it. For example,
Code:
=IF(A61,"black","")
will display "black" in the cell when A6 is greater than 1, and leave the cell blank otherwise.