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.