Conditional Formatting

  • Thread starter Thread starter itty
  • Start date Start date
I

itty

Can I do conditional formatting with more than 3 conditions.
Thanks in advance.
Rgds,
Itty.
 
Hallo,

it's not possible to have more than 3 conditional formatting. I looked
even in visual basic but the helpfile said that when you trie more then
3 it gives an error. so no more then 3

Greetings
 
Hi Itty,

actually you can apply 4 different formats (3 through the conditional
format dialog and one as default format). For more than 4 different
formats you need VBA code (process the workbook_change event).



If you only want to apply different font colors, you can define up to 6
different style. See:
http://www.mcgimpsey.com/excel/conditional6.html
for instructions how to do it

Further links for this topic:
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

HTH
Frank
 
Back
Top