R rp Oct 5, 2004 #1 conditional formating offers up to 3 conditions only. what if i have 6 conditions. how will i do that.
conditional formating offers up to 3 conditions only. what if i have 6 conditions. how will i do that.
F Frank Kabel Oct 5, 2004 #2 Hi you'll need VBA for this. See: http://www.mvps.org/dmcritchie/excel/event.htm
D Debra Dalgleish Oct 5, 2004 #3 J.E. McGimpsey has instructions for a non-macro method on his web site: http://www.mcgimpsey.com/excel/conditional6.html
J.E. McGimpsey has instructions for a non-macro method on his web site: http://www.mcgimpsey.com/excel/conditional6.html
