Conditional Format & Formula

[Guest]

Each cell in a column of data contains a formula that produces a numerical
value (see below). Within each cell, I want to set formatting so that
whichever cell contains the highest value in the column, it will be shaded
Pale Blue.

Column Value Produced by Formula
=IF(B3=0,0,G3/C3) 12.0
=IF(B3=0,0,G4/C4) 24.0
=IF(B4=0,0,G5/C5) 34.0
=IF(B5=0,0,G6/C6) 14.0
=IF(B6=0,0,G7/C7) 8.0

In this example, Row 3 would be shaded Pale Blue because it contains the
largest value. The other cells would retain a No Fill format.

Can anyone help?

Thanks,
Bob

 

[Guest]

Select all the cells you want to format this way, let's say they are cells
H3:H7
Select Format->Conditional Format
Select 'Cell value is" and 'equal to' and then enter =MAX($H$3:$H$7)
Click on the Format button, select the Pattern tab and select light blue
OK your way back to the spreadsheet

 

[Guest]

Thank you. That works and is a hugh help.

Bob

Select all the cells you want to format this way, let's say they are cells
H3:H7
Select Format->Conditional Format
Select 'Cell value is" and 'equal to' and then enter =MAX($H$3:$H$7)
Click on the Format button, select the Pattern tab and select light blue
OK your way back to the spreadsheet