Conditional Formatting Confusion

[Karen]

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? I’m confused.
Any help would be greatly appreciated, Karen

 

[Don Guillett]

As always post your conditional formatting formula for comments

 

[Ron Rosenfeld]

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? I’m confused.
Any help would be greatly appreciated, Karen

Most likely the result of your formula is not EXACTLY 5.4.

One fix would be to modify your conditional formatting formula to take that
into account.

Another fix would be to ROUND the formula in the cell to one digit after the
decimal.
--ron

 

[Gord Dibben]

The calculated value of 5.4 may not be exactly 5.4.

Increase decimal places and you may find the value is 5.37001 or similar.

In that cae you have to use the ROUND function to get your value to 5.4


Gord Dibben MS Excel MVP

 

[Karen]

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]

rounding..............

 

[Karen]

Thank you, but I'm not sure how to round if there's a formula in the cell.
The formula is: =D19 X e19 x F19 x 0.0001
How can this be done?
Thank you VERY much, Karen

 

[Gord Dibben]

The ROUND function can be located in Excel help.

Basics are

=ROUND(D19*E19*F19,1) to get 1 DP

=ROUND(D19*E19*F19,0) to get no DP


Gord Dibben MS Excel MVP

 

[Karen]

Thanks! I didb't realize that it was so easy.
Have a great weekend, Karen