I did it close to that way initially and it worked but then I changed the
cells formatting to add the word DAYS. This is how i did it initially

1st condition - Select the range and choose Format, Conditional Formatting
From the second drop down choose greater than and in the 3rd box enter 30(31
and above)
Click Format and on the Patterns tab pick a color (green), click OK once.

2nd condition - Click Add and from the second drop down for the choose less
than and in the 3rd box enter 16(15 and below) than pick (red)

3rd condition - Click Add and from the second drop down for the choose
between to and in the 3rd box enter 31 and 15. (30-16)
than I pick yellow.

Now that the word DAYS is in the cell the formatting will not work.




"Shane Devenshire" wrote:

Hi,

First there is an overlap of conditions:
Above 30 is green
31 is yellow?
Similar problem with between 15-31
and below 16.

No formulas necessary!

Let's suppose you really want this

1. Select the range and choose Format, Conditional Formatting
2. From the second drops down choose greater than and in the 3rd box enter 30
3. Click Format and on the Patterns tab pick a color (green), click OK once.
4. Click Add and from the second drop down for the 2nd condition choose
greater than and in the 3rd box enter 15.
5. Repeat step 3 picking Yellow
6. Click Add and from the second drop down for the 2nd condition choose less
than or equal to and in the 3rd box enter 15.
7. Repeat step 3 picking Red.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Josh" wrote:

OK this is going to be hard to explain.

OK I want to set conditional formatting for a set of numbers. The cells i
am trying to format says anything from 365 - 0 DAYS.
I am trying to get the cell to
turn green when it is above 30 Days
Yellow when it is between 31 and 15
red when it is below 16.

I had it working before I added the work DAYS to the cell. Now I can not
figure out how to make that conditional formatting work when the word "DAYS"
is in the cell.