Conditional Formatting not working?

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

does the cell change from O to X ok
can we see a spreadsheet attached

you may try using a formula input

Z25 = "O" - red

Z25 = "X" - green

OR

just looking quickly at this, it seems you have Z25 formula the wrong way round.

atm, when Y25 DOES NOT EQUAL AA25, show O, otherwise show X
P.S. surely is would be easier to put =if(Y25=AA25,"O","X")

Hello a8015945,
I have changed the formula to your suggestion =if(Y25=AA25,"O","X") and now Z25 turns into a green X but not a red O when Y25 is not equal to AA25.

Unfortunately I am unable to upload the sheet because I am on a works computer!

Thank you for your help.

Hello a8015945,
I have changed the formula to your suggestion =if(Y25=AA25,"O","X") and now Z25 turns into a green X but not a red O when Y25 is not equal to AA25.

Unfortunately I am unable to upload the sheet because I am on a works computer!

Thank you for your help.

Hello etaf,

the cell does not change to an X or a O no!
I have two conditions in the conditional formatting yes one red for the O and one green for the X.
If I type in an X or a O (overwriting the formula) then the cells turns color accordingly indicating that the conditional formatting is working as it should do. The problem appears to be within the formulas but I do not understand where!

i have edited my post and added the example

As JosephP replied, looks like your formula maybe correct - but the values not actually equal and so check the decimal places
and apply the round as suggested

OK i think I've solved it.

I think what you need to do is compare Y25 and AA25 as a conditional format, instead of looking for O or X.
By this i mean, select Z25, conditional formatting -> new rule -> use a formula -> =($Y$25=$AA$25) --- Green
Then do the same for red, select Z25, new rule -> use a formula -> =($Y$25<>$AA$25) --- Red

You can still use an IF statement in Z25 to show O or X, but now the formatting looks at the two cells (Y25 and AA25)

a8015945 both ways should work - the O and X and the formulas

its more likely the decimal issue, as replied by JosephP , as the formula for putting an O or an X does not work, nor will using the same formulas for a cond frmt