Ok. But, how do I apply this "default" to a column that already has
conditional formatting set? Since the three conditions are already set, where
or how to tell the established formatting to us no color if it meets none of
these conditions?

Thanks for replying!

"Gord Dibben" wrote:

Amy

The fourth is the default "no color".


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 09:55:02 -0700, Amy wrote:

Hi Saruman,

Could you explain how to format the cell with the base colour? Not sure
what you mean?

I need four colors. I have already green, yellow, and red. I just need one
more color which would be white.

1. if it is less than 1 (100%) then green
2. if it is greater than 1 but less than 1.25 then yellow
3. if it is greater than 1.25 then red
4. if it is "NA" then white

I apply the conditional formatting to a single column that has a forumla in
each cell.

Please advise. Thanks!
Amy

"Saruman" wrote:

If you format all the cells with a base colour before adding the conditional
formats then you will have 4 colours available

Saruman

----------------------------------------------------------------------------
---------
All Outgoing Mail Checked With Norton Antivirus 2003
----------------------------------------------------------------------------
---------

"penri0_0" wrote in
message ...

Hi,

Is there any way i can format a cell with more than 3 conditions?

Thanks in advance


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile:
http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=542559