Change the formula back to:

=E105+365-TODAY()

and use Format | Cells | Number tab | Custom (at bottom of list). In
the Type: box enter:

0"DAYS"

(exactly as it appears above) and click OK, and then you will not have
to include the word DAYS in your formula. You previous Conditional
Formatting (based on numeric values) should now work, as you do not
have the word DAYS actually in the cell.

Hope this helps.

Pete

On Jan 6, 11:46*pm, Josh wrote:
this is my formatting for the cells I am tring to do the conditional
formatting on

=E105+365-TODAY()&" DAYS"



"Pete_UK" wrote:
Presumably you had a formula which worked out days (as a number)
before, and you have now changed it to return &" DAYS" at the end, and
so it is now text. You can get the word DAYS to show in the cell
through formatting, so that your previous conditional formatting will
still work on the underlying numbers - use a custom format on the cell
of:

0" days"

Hope this helps.

Pete

On Jan 6, 8:54 pm, 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.- Hide quoted text -

- Show quoted text -