The default format is the default format - it's the one that's already
there. If you don't like the settings, right click on the cell and select
"Format Cells"

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Sue" wrote in message
...
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 :-)