Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Conditional Formating

Posted by Colin on February 10, 2002 2:23 PM

When applying a basic conditional format to a cell such as ifA1 ="Sick"... colour RED. There is only three senario's availible - can this be expanded if so how can it be done ??

Re: Conditional Formating

Posted by Yogi Anand on February 10, 2002 7:57 PM

Hi Colin:
You can only apply upto 3 conditions and no more.
HTH

Re: Conditional Formating

Posted by Randy on February 11, 2002 2:16 AM

I seem to remember seeing (on this board) a macro that would increase that from 3 to 5, so you can do at least that.
I don't remember what date it was, but I'm sure I copied that reply. If I can find it among all my unorganized notes, I'll post. But it can be done.

Randy

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.