Question

Excel format cell based on another cell and condition

Answer 1

Answer:

heya mate✌

Highlight Excel Cells Based on the Value of Another Cell

Highlight Excel Cells Based on the Value of Another CellSelect 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. ...

Highlight Excel Cells Based on the Value of Another CellSelect 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 

.....hope it hlps❣

Answer 2

Explanation:

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.