View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Josh is offline
external usenet poster
 
Posts: 103
Default Conditional formatting

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.