If you wish to change the color of the font based on the value in a cell, you will need to apply conditional formatting.
To do this, select the cell that you wish to apply the formatting to. In this example, we've selected cell B8.
Under the Format menu, select Conditional Formatting.
When the Conditional Formatting window appears, enter the first condition. In our example, we've selected when the cell value is greater than 10.
Next, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.
When the Format Cells window appears, select the formatting conditions that you wish to apply. We've changed the Color to Red. Then click on the OK button.
If you wish to apply more than one condition, you will need to click on the Add button.
We've added three different conditions. When you're done, click on the OK button.
Now when you return to the spreadsheet, the conditional formatting will be applied. As you can see, the value in cell B8 appears in red.
To do this, select the cell that you wish to apply the formatting to. In this example, we've selected cell B8.
Under the Format menu, select Conditional Formatting.
When the Conditional Formatting window appears, enter the first condition. In our example, we've selected when the cell value is greater than 10.
Next, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.
When the Format Cells window appears, select the formatting conditions that you wish to apply. We've changed the Color to Red. Then click on the OK button.
If you wish to apply more than one condition, you will need to click on the Add button.
We've added three different conditions. When you're done, click on the OK button.
Now when you return to the spreadsheet, the conditional formatting will be applied. As you can see, the value in cell B8 appears in red.
Comments