or perhaps
http://www.mvps.org/dmcritchie/excel/event.htm#case
which may be of more help if you are not familiar with Event macros., installation
starting in the middle you miss the installation note at top which is to
right click on the sheet tab, view code, insert your code (modified, of course)


or with the use of an addin, you can have additional condiiton colors, see
CFPlus - Extended Conditional Formatter by Bob Phillips and Frank Kabel
http://www.xldynamic.com/source/xld.....Download.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark Lincoln" wrote in message oups.com...
Take a look at this site:

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm