You are posting to the programming newsgroup which has nothing to do
with ExcelForum -- what do you mean by removed. The complete thread
as seen in the Google Groups archive (12 hour delay) is ...

http://google.com/groups?threadm=10f....supernews.com

Since I have posted to this thread might as well add my own link
http://www.mvps.org/dmcritchie/excel/event.htm#case
as the normal solution when you need more than 3 conditional formats.
---
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

"whisperer " wrote in message ...
Removed as it is covered adequately above


---
Message posted from http://www.ExcelForum.com/