Conditional Format Limitation

  • Thread starter Thread starter melvin
  • Start date Start date
M

melvin

Hi folks,

I am looking to impose 4 conditions on an array of cells using th
conditional formatting tool, however it seems to have a limit of only
conditions!

Is there any way around this limit?

Any suggestions are greatly appreciated!

melvi
 
Hi Melvin
conditional format only accepts 3 conditions though you have a fourth
if you include the default format. So maybe this is sufficient for you.

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

For everything else you'll need VBA code (e.g. process the
worksheet_change event and apply your format based on the cell values)

HTH
Frank
 
First, if your range will always have one of the conditional formats
applied, use regular formatting for the first or "base" case, then the
three CFs for the others.

You may be able to get up to 6 formats if at least three of them are
font colors. See

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

Otherwise you'll need to use a macro. Check the archives for dozens of
ways:

http://groups.google.com/advanced_group_search?q=group:*excel*

You might like to look at David McRitchie's Conditional Formatting page
as well:

http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
Back
Top