more than 3 conditional formats

[abailey]

Is it possible to add more than 3 conditional formats to a particula
cell?

Any help would be much appreciated.

Thanks,
-

 

[Harald Staff]

Hi A

No, you'd need a macro to do the formatting with >3 conditions.

HTH. Best wishes Harald

 

[JE McGimpsey]

Depending on the conditions, you may be able to get up to 6 *font*
formats:

http://www.mcgimpsey.com/excel/conditional6.html

Otherwise you'll need to use an event macro. See

http://www.mvps.org/dmcritchie/excel/event.htm#case

for an example.

 

[abailey]

I really appreciate it!!