Question

Excel how to format a cell based on another cell value

Answer 1

Answer:

In many cases, you will base the formatting rule for your Excel cells on how they compare to the value of another cell. Take the example illustrated here. The cells are conditionally highlighted if their respective values fall below the Prior Year Average shown in cell B3.

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

This selection evaluates values based on a formula you specify. If a particular value evaluates to TRUE, the conditional formatting is applied to that cell.

In the formula input box, enter the formula shown with this step.

Note that you are simply comparing your target cell (E3) with the value in the comparison cell ($B$3). As with standard formulas, you need to ensure that you use absolute references so that each value in your range is compared to the appropriate comparison cell.

please mark me brainliest....