If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can conditional formatting be applied in more then three instance
|
#2
|
|||
|
|||
can conditional formatting be applied in more then three instance
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 On Tue, 20 Dec 2005 17:07:02 -0800, Mary jane wrote: |
#3
|
|||
|
|||
can conditional formatting be applied in more then three instance
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 "Gord Dibben" gorddibbATshawDOTca wrote in message ... 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 On Tue, 20 Dec 2005 17:07:02 -0800, Mary jane wrote: |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
conditional formatting question | Deb | General Discussion | 0 | March 23rd, 2005 02:07 AM |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |
Freezing Conditional Formatting | Ashish Chamaria | Worksheet Functions | 3 | December 19th, 2003 10:54 AM |