Excel: How to Change Font Color Based on Cell Value


To change the font color of cells in Excel based on the cell value, you can use the New Rule option under the Conditional Formatting dropdown menu within the Home tab.

The following example shows how to use this option in practice.

Example: Change Font Color Based on Cell Value in Excel

Suppose we have the following dataset in Excel that shows the total sales made by various employees at some company:

Now suppose we would like to change the font color of the values in the Sales column to be red if they are greater than 10.

To do so, we can highlight the cells in the range B2:B13, then click the Conditional Formatting dropdown menu on the Home tab and then click New Rule:

In the new window that appears, click Use a formula to determine which cells to format, then type =$B2>10 in the box, then click the Format button:

In the new window that appears, click the Font tab along the top, then click the dropdown menu next to Color and choose a font color to use for each of the cells that have a value greater than 10.

We will choose red:

Next, click OK.

Then click OK once more to apply the changes to the cells:

Excel change font color based on value

We can see that all of the cells in the range B2:B13 that have a value greater than 10 now have red font.

Note: We chose to use red font for the conditional formatting in this example, but you can choose any color and style you’d like for the conditional formatting.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel: Apply Conditional Formatting to Overdue Dates
Excel: Apply Conditional Formatting Based on Adjacent Cell
Excel: Apply Conditional Formatting Based on Multiple Conditions

Featured Posts

Leave a Reply

Your email address will not be published. Required fields are marked *