can conditional formatting be applied in more then three instance

[Gord Dibben]

Conditional Formatting allows 3 conditions......4 if you count default.

John McGimpsey shows how to get 6 font colors if the data is numeric.

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

Other than that, you must use VBA code.

On the other hand, if you mean by more than 3 instances, can you apply to more
than three cells, yes you can.

Re-post with a description of your needs in the body of your post.

Hard to get a feel for that when the subject header is truncated.


Gord Dibben Excel MVP

 

[David McRitchie]

Hi MaryJane,

that would be per cell, other cells can have other conditions. Take a look at
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you want more than 3 conditions, the normal thing to do is/was
to use an event macro
http://www.mvps.org/dmcritchie/excel/event.htm#case

but you can use extended conditional formatting addin that
interfaces like the builtin conditional formatting to utilize more
colors -- 56 colors is the limit of the color palette.
The link will be found on m condfmt.htm page.

If you wrote your question in the body of text, we would know
that we were really seing the question and perhaps your
wording would not use the ambiguity of instances which is
subject to a lot of interpretations.

It would be most efficient to assign condtional formatting
to entire columns rather than copying the formatting down
as you fill in more rows of data.

HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm