Where before you might have had =A130 as the condition for green, now use
=--(IF(LEN(A1)7,(LEFT(A1,3),LEFT(A1,2)))30

Same for the others, if you had them working with just a number now use
=--(IF(LEN(A1)7,(LEFT(A1,3),LEFT(A1,2))) in place of the cell reference.

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