Archive of Mr Excel Message Board

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

Conditional Formating for > 3 levels

Posted by Aissatou on February 05, 2002 7:55 AM

Hi,

I am somewhat new to Excel and need your help. I am presently working with this formula which returns the following conditions: Closed, Comments Past Due, Comment Due, Submittal Past Due and Pending. I am trying to use conditionally formating to color-code these responses. However, I am only able to do so for 3 conditions. Is there a formula I can use to enable upto 5 conditions?

Thank you for your assistance.

Aissatou

Re: Conditional Formating for > 3 levels

Posted by Chris D on February 05, 2002 1:41 PM

Nope, only 3 allowed for 3 different colours

(4 if you include the absence of other criteria)

:-(

Re: Conditional Formating for > 3 levels

Posted by JACK IN THE UK on February 05, 2002 2:25 PM

Hi Aissatou--
Ok you can onlt do 3 conditions, but i can write VBA code to have , dont know limit a have 25 or so all colour rows colour but can edit easy to whatever.. intrested let me know ill email from work to you. i will need your email. Im not promising a 5 minute answwer but i will always email...

your call
HTH
Rdgs
Jack

Re: Conditional Formating for > 3 levels

Posted by Aissatou on February 12, 2002 11:38 AM

Thank Chris for responding.

Re: Conditional Formating for > 3 levels

Posted by Aissatou on February 12, 2002 11:40 AM

Thanks Jack. My email is Dalanda@aol.com.

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.