Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Okay, let me try to explain this correctly.
I have 3 columns. Column 1 is "lap one time", Column 3 is a "total time", Column 2 is the difference between the two times ("lap two time"). I have setup Conditional Formating on Columns 1 & 3 to highlight the lowest time (=B3 = MIN($B$3:$B$93), etc). This works fine. However I would also like to format Column 2 (the column with the formula for "Lap 2 time") to show the smallest time there. I've tried =D3-B3 = MIN($B$3:$B$93) and =D3-B3 = MIN($D$3-$B$3:$D$93-$B$93) but nothing seems to work. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another Conditional format question | Excel Worksheet Functions | |||
conditional format | Excel Discussion (Misc queries) | |||
Conditional Format - 3 conditions | Excel Worksheet Functions | |||
Conditional format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |