Hello Everyone,

I have made a sheet that contains conditional formatting that changes when a condition is met but it is not working for some reason when the cells have equal values?
Below is the description:

Cell Y25 contains the following formula:
=(E25*F25+SUM(H25:X25)) this produces: $801.75

Cell Z25 contains the following formula:
=IF(Y25<>AA25,"O","X")

And the following conditional formatting is also in cell Z25:
Condition1
Cell Value Is - equal to - ="X" (Change cell color to green)

Condition2
Cell Value Is - equal to - ="O" (Change cell color to red)

I then type $801:75 into cell AA25 but cell Z25 stays as a red X! It should turn to a green O because cells Y25 and AA25 both have the same value of $801.75!
I have no idea why but have checked the cell formatting and it is the same in both cells Y25 and AA25?

Thank you for any help.

Margate