Question

How to set conditional formatting in excel based on another cell?

Answer 1

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.