H
Horatio J. Bilge, Jr.
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
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