Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using excel 2003 and would like to use conditional formatting to
highlite the 120 day column with the highest % for each site regardless of month. For example for Phil it would be 98.16, for Mech it would be 96.42. Any help would be much appreciated. Thanks. site Mon/Yr 60 day 90 day` 120 day Phil Jan-06 89.61 95.54 96.75 Mech Jan-06 85.44 93.54 95.02 Nua Jan-06 88.44 93.58 95.6 Phil Feb-06 92.77 96.37 98.16 Mech Feb-06 87.81 95.6 96.43 Nua Feb-06 88.89 93.71 96.04 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional tab formatting? | Excel Discussion (Misc queries) |