I need at least 5 colors formatting!

[saud]

Ok guys thanks so much but I have tried Conditional Formatting, its fine
only if it’s for 3 levels formatting but actually I need at least 5
colors formatting!

What to do??

Any suggestion?

Thanks,

 

[Don Guillett]

It would have been helpful to all if you had mentioned that to start with.
You will need code. Details would be helpful.

 

[J.E. McGimpsey]

This is a very frequently asked question. Search the archives:

http://google.com/advanced_group_search?q=group:*excel*&as_scoring=d

use "Conditional Format more" (without quotes) as a search term

 

[David McRitchie]

One place is my site.
Event macros
http://www.mvps.org/dmcritchie/excel/event.htm#case
then look at the beginning for how to install an event macro
(right click on sheet tab, they are not the same as regular macros).