tech on the net

MS Excel: Change the font color based on the value in the cell in Excel 2003/XP/2000/97

See solution in other versions of Excel:

Question: In Microsoft Excel 2003/XP/2000/97, I'm putting the sum of 3 cells in a 4th cell. If the sum is greater than 10, I would like the sum to be the color red. If the sum is less than 10, I would like the sum to be the color blue. If the sum equals 10, I want the font color to be black. Is this possible?

Answer: 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.

Microsoft Excel

Under the Format menu, select Conditional Formatting.

Microsoft Excel

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.

Microsoft Excel

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.

Microsoft Excel

If you wish to apply more than one condition, you will need to click on the Add button.

Microsoft Excel

We've added three different conditions. When you're done, click on the OK button.

Microsoft Excel

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.

Microsoft Excel