Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format if the cell contains a formula | Excel Worksheet Functions | |||
Conditional format formula | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Conditional Format Formula Needed | Excel Worksheet Functions |