Excel formula to change cell color without conditional formatting

In Excel, you can change the cell color based on the value of another cell using conditional formatting.

For example, you can highlight the names of sales reps in column A based on whether their sales are more than 450,000 or not (which is a value we have in cell D2).

This tutorial covers three techniques for changing cell color based on the value of another cell in Excel.

Change Cell Color Based on Value in Another Cell (Using Formula)

Conditional Formatting is a feature in Excel that allows you to format cells based on particular criteria or conditions.

If the specified criteria are met, conditional formatting will highlight the cell; else, it will not.

While in most cases, conditional formatting is used to highlight cells based on the values in the cells themselves, you can also color these cells based on values in some other cell or column.

Let’s see two methods you can use to apply conditional formatting to change cell color based on the value in another cell.

Method 1 – Using Formula within Conditional Formatting

Suppose we have the followi

how to create a color coded formula in excel

how to put color in if function in excel