software

Hi,

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

Thanks in advance--
penri0_0------------------------------------------------------------------------
penri0_0's Profile: www.excelforum.com/member.php...oamp;userid=28947
View this thread: www.excelforum.com/showthread...hreadid=542559Depends on your conditions. Do you need more than three formats, or do
you need more than three conditions? Please post the conditions.
Hi Dave
I have four ranges:

0 to 9999
10,000 to 19,999
20,000 to 29,999
and 30,000 to 39,999

on an invoice spreadsheet. If the value of an invoice falls within one
of these ranges i want it to shade the cell a different colour.

thanks--
penri0_0------------------------------------------------------------------------
penri0_0's Profile: www.excelforum.com/member.php...oamp;userid=28947
View this thread: www.excelforum.com/showthread...hreadid=542559
Hello penri0_0,

Apparently we have the same problem.
Maybe you can learn something from my posting he
www.excelforum.com/showthread.php?t=542791

Succes!--
Lucas Lehmer
------------------------------------------------------------------------
Lucas Lehmer's Profile: www.excelforum.com/member.php...oamp;userid=34514
View this thread: www.excelforum.com/showthread...hreadid=542559
Thanks Lucas, i'll give it a go although i've got little experience
programming! --
penri0_0------------------------------------------------------------------------
penri0_0's Profile: www.excelforum.com/member.php...oamp;userid=28947
View this thread: www.excelforum.com/showthread...hreadid=542559The only thing I know you can do is format the cell to your first condition
under Format Cells the conditionally format for the other three. Here is a
link posted here before but I never tried.

www.xldynamic.com/source/xld.....Download.htmlTC
quot;penri0_0quot; wrote:

gt;
gt; Hi,
gt;
gt; Is there any way i can format a cell with more than 3 conditions?
gt;
gt; Thanks in advance
gt;
gt;
gt; --
gt; penri0_0
gt;
gt;
gt; ------------------------------------------------------------------------
gt; penri0_0's Profile: www.excelforum.com/member.php...oamp;userid=28947
gt; View this thread: www.excelforum.com/showthread...hreadid=542559
gt;
gt;

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
----------------------------------------------------------------------------
---------

quot;penri0_0quot; gt; wrote in
message news
gt;
gt; Hi,
gt;
gt; Is there any way i can format a cell with more than 3 conditions?
gt;
gt; Thanks in advance
gt;
gt;
gt; --
gt; penri0_0
gt;
gt;
gt; ------------------------------------------------------------------------
gt; penri0_0's Profile:
www.excelforum.com/member.php...oamp;userid=28947
gt; View this thread: www.excelforum.com/showthread...hreadid=542559
gt;
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 quot;NAquot; then white

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

Please advise. Thanks!
Amy

quot;Sarumanquot; wrote:

gt; If you format all the cells with a base colour before adding the conditional
gt; formats then you will have 4 colours available
gt;
gt; Saruman
gt;
gt; ----------------------------------------------------------------------------
gt; ---------
gt; All Outgoing Mail Checked With Norton Antivirus 2003
gt; ----------------------------------------------------------------------------
gt; ---------
gt;
gt; quot;penri0_0quot; gt; wrote in
gt; message news
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; Is there any way i can format a cell with more than 3 conditions?
gt; gt;
gt; gt; Thanks in advance
gt; gt;
gt; gt;
gt; gt; --
gt; gt; penri0_0
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; penri0_0's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28947
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=542559
gt; gt;
gt;
gt;
gt;

Amy

The fourth is the default quot;no colorquot;.Gord Dibben MS Excel MVP

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

gt;Hi Saruman,
gt;
gt;Could you explain how to format the cell with the base colour? Not sure
gt;what you mean?
gt;
gt;I need four colors. I have already green, yellow, and red. I just need one
gt;more color which would be white.
gt;
gt;1. if it is less than 1 (100%) then green
gt;2. if it is greater than 1 but less than 1.25 then yellow
gt;3. if it is greater than 1.25 then red
gt;4. if it is quot;NAquot; then white
gt;
gt;I apply the conditional formatting to a single column that has a forumla in
gt;each cell.
gt;
gt;Please advise. Thanks!
gt;Amy
gt;
gt;quot;Sarumanquot; wrote:
gt;
gt;gt; If you format all the cells with a base colour before adding the conditional
gt;gt; formats then you will have 4 colours available
gt;gt;
gt;gt; Saruman
gt;gt;
gt;gt; ----------------------------------------------------------------------------
gt;gt; ---------
gt;gt; All Outgoing Mail Checked With Norton Antivirus 2003
gt;gt; ----------------------------------------------------------------------------
gt;gt; ---------
gt;gt;
gt;gt; quot;penri0_0quot; gt; wrote in
gt;gt; message news
gt;gt; gt;
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; Is there any way i can format a cell with more than 3 conditions?
gt;gt; gt;
gt;gt; gt; Thanks in advance
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; penri0_0
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; penri0_0's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=28947
gt;gt; gt; View this thread: www.excelforum.com/showthread...hreadid=542559
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt; Ok. But, how do I apply this quot;defaultquot; 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!

quot;Gord Dibbenquot; wrote:

gt; Amy
gt;
gt; The fourth is the default quot;no colorquot;.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Thu, 20 Jul 2006 09:55:02 -0700, Amy gt; wrote:
gt;
gt; gt;Hi Saruman,
gt; gt;
gt; gt;Could you explain how to format the cell with the base colour? Not sure
gt; gt;what you mean?
gt; gt;
gt; gt;I need four colors. I have already green, yellow, and red. I just need one
gt; gt;more color which would be white.
gt; gt;
gt; gt;1. if it is less than 1 (100%) then green
gt; gt;2. if it is greater than 1 but less than 1.25 then yellow
gt; gt;3. if it is greater than 1.25 then red
gt; gt;4. if it is quot;NAquot; then white
gt; gt;
gt; gt;I apply the conditional formatting to a single column that has a forumla in
gt; gt;each cell.
gt; gt;
gt; gt;Please advise. Thanks!
gt; gt;Amy
gt; gt;
gt; gt;quot;Sarumanquot; wrote:
gt; gt;
gt; gt;gt; If you format all the cells with a base colour before adding the conditional
gt; gt;gt; formats then you will have 4 colours available
gt; gt;gt;
gt; gt;gt; Saruman
gt; gt;gt;
gt; gt;gt; ----------------------------------------------------------------------------
gt; gt;gt; ---------
gt; gt;gt; All Outgoing Mail Checked With Norton Antivirus 2003
gt; gt;gt; ----------------------------------------------------------------------------
gt; gt;gt; ---------
gt; gt;gt;
gt; gt;gt; quot;penri0_0quot; gt; wrote in
gt; gt;gt; message news
gt; gt;gt; gt;
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; Is there any way i can format a cell with more than 3 conditions?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks in advance
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; penri0_0
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; ------------------------------------------------------------------------
gt; gt;gt; gt; penri0_0's Profile:
gt; gt;gt; www.excelforum.com/member.php...oamp;userid=28947
gt; gt;gt; gt; View this thread: www.excelforum.com/showthread...hreadid=542559
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;