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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel 2007 - A Conditional Formatting ?'s 1
Conditional Formatting 2
Excel Highlighting duplicates 0
Conditional Format 5
Conditional Formatting - Excel 2003 2
Conditional Formatting - more than 3 conditions 4
Conditional formating problem. Please help. 7

Back
Top