Sorry
The formula is: =D19 X e19 x F19 x 0.0001
D19 = 63
E19 = 860
F19 = 0.0001

The conditional formatting is:
Condition 1: Greater than or equal to 0.1
Condition 2: Less Than or Equal to 5.4

OK, not this is weird. I just applied the conditional formatting to several
cells and they all turned the color I specified. Some are within the
parameters and some are outside the 0.1 and 5.4.
HELP!


"Don Guillett" wrote:

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


.