Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am having trouble with some conditional formatting of times. I set up a
rule so that if a value in D2:M2 is less than or equal to the value in C2, it will be highlighted (yellow background). The problem is that C2 is based on an average. For example, C2 says 0:43.2, but it is actually 0:43.19. Cell J2 is 0:43.2 (exactly), and I want it to be highlighted, but it isn't. If it helps, here is more detail on the workbook setup... Sheet1 through Sheet3 have times to the tenth of a second in D2 through M2 (i.e., m:ss.0), and N2=AVERAGE(D2:M2). On Sheet4, I calculate the minimum of the averages in C2=MIN('Previous:May-08'!N2). Sheet4 is the one with the conditional formatting. Thanks, ~ Horatio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Discussion (Misc queries) | |||
Conditional formatting error | Excel Discussion (Misc queries) | |||
Conditional Formatting error | Excel Discussion (Misc queries) | |||
conditional formatting for Error | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions |