Question

How to conditional format one cell based on another cell?

Answer 1

To create a conditional formatting rule:

Select the desired cells for the conditional formatting rule.

From the Home tab, click the Conditional Formatting command. ...

Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears. ...

A dialog box will appear.

Answer 2

Explanation:

Highlight Excel Cells Based on the Value of Another Cell

Select the data cells in your target range (cells E3:C14 in this example), click the Home tab of the Excel Ribbon, and then select Conditional Formatting→New Rule. ...

In the list box at the top of the dialog box, click the Use a Formula to Determine which Cells to Format option.