Hi, thanks for taking the time to respond. I'm not sure I fully understand.
I can set the 3 conditional formats using Blue, Green and Yellow and have the
default format in Red or another of the colors if I choose? How do I set the
default format (probably a silly question but I ask just the same).

Thanks for you assistance

"Temp" wrote:

You can have three conditional formats PLUS the underlying default
format - that's four :-)