advance conditional formating

[rp]

conditional formating offers up to 3 conditions only. what if i have 6
conditions. how will i do that.

 

[Frank Kabel]

Hi
you'll need VBA for this. See:
http://www.mvps.org/dmcritchie/excel/event.htm

 

[Debra Dalgleish]

J.E. McGimpsey has instructions for a non-macro method on his web site:

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