As always post your conditional formatting formula for comments
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Karen" wrote in message
...
I have a cell that contains the value 5.4. The value is a result of a
calculated formula. There is conditional formatting set up in that cell
and
it's not turning a different color. When I type in 5.4 in that cell, the
cell
color changes accordingly. What could be causing this to happen? Im
confused.
Any help would be greatly appreciated, Karen