Conditionally format columns

**aias** · 08-27-2008, 03:26 PM

I've got a problem that i can't seem to fix

I've got columns that i want to conditionally format

the first is a status column and the second is a wait time
What i want to do is have the wait time column go red after a certain number of days at a status .. now here's the problem

For Status A I want that turn red number to be 10 days
for status b i want it to be 2 days

the status selections are dropdown list and the dates are automatically generated with a DateDif.

this is beyond me but it would be really helpful

**Kenneth Hobson** · 08-27-2008, 05:20 PM

I am confused. You said column B was wait time. You said date was from a datedif. How does that relate? A short example xls might clear it up.

Most likely, a Time() in a conditional format like Formula Is: =A1+10<=TODAY()

**mikerickson** · 08-27-2008, 06:17 PM

A helper column "Date of status change" might be a help.

Absent that, I can only suggest a Worksheet_Change event that sets the CF of Col B when the Col A cell (same row) is changed.

**Leith Ross** · 08-28-2008, 01:10 AM

Hello aias,

Welcome to the Forum!

As a new member please take time to read over the Forum's rules. I changed your post title to reflect your question. This will aid others in searching for answers and help you help get a quicker response to your questions.

Sincerely,
Leith Ross