Here is an example, I know why its turning my cell red but how can I fix
that decimal problem with conditional formatting?
Data Cell M69 is formatted to read 00:30 Minutes
N69 is formatted to read 0:30 Minutes
Conditional Format in cell M69 is
Cell value is greater than N69 then red
ok
the acutal excel machine language format for cell M69 is
0.0208333333357587
the actual excel machine language format for cell N69 is
0.0208333333333333
I have changed the formats for them to look the same and that didnt
cure anything. I mean its meeting the conditions to change it red but
how can I write in an override or something?
Ed
--
changetires
------------------------------------------------------------------------
changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
View this thread:
http://www.excelforum.com/showthread...hreadid=564803