Conditional Format & Formula
 

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

Conditional Format & Formula
 

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


"bob" wrote:

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

Conditional Format & Formula
 

Thank you. That works and is a hugh help.

Bob

"Duke Carey" wrote:

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


"bob" wrote:

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