Strange colour formatting

[WatfordKev]

I have a cell with the following formula. As well as setting the value ("green" "red" or "amber") the background of the cell gets coloured green red or amber, and I can't see how or why - any ideas welcome!

=IF(OR(N28="",AH28=""),"",IF(AND(AG28=0,AH28=0),"Green",IF($H28="High",IF(AI28>=O28,"Green",IF(AI28<=P28,"Red","Amber")),IF($H28="Low",IF(AI28<=P28,"Green",IF(AI28>=O28,"Red","Amber")),""))))

NB! Even if I type 'Red' 'Green' or 'Amber' in the cell, the background colour changes...

 

[VoG]

Sounds like you have Conditional formatting applied.

 

[WatfordKev]

Hi Peter

I did wonder this! Thanks Peter, I just found it at last! Thanks!