Sorry my mistake ... you can't get more then 3 Conditional Formats
easily.

If font color is not what you want, 1 is ruled out
Since you ruled out Add-in, 2 is not an option
And if you don't want VBA, 3 is ruled out as well.

1. http://www.mcgimpsey.com/excel/conditional6.html
2. http://www.xldynamic.com/source/xld.....Download.html
3. http://www.mvps.org/dmcritchie/excel/condfmt.htm

As hard as it may sound....those are your options.
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390557