You're welcome. Glad you got it to work.
The fact that whenever AB52 is Red, the outcome is Red regardless of cell
AB4 content, allowed the first IF to take out a couple of the others you had
wanted to include.

Regards

Roger Govier


AmyTaylor wrote:
Roger, ignore last post ! I had stupidly forgotten to change your "g",
"r" and "a" to green, red and amber !!
It works perfectly !!
Thank you Amy X