Condition formating on due dates between a row of dates

**irismarcial** · 09-11-2012, 01:59 PM

Hello All ,

I have a file that i'm tryiing to condition...I need for cells to turn red when pass due.

So btween colum H and I there are 2 dates...so in the event that I don't send my information to PM and he didn't send it back I want the cell to turn red if its 3 days past the due date? I'm not sure if i'm explaining thie right...but I need some help.

**ChemistB** · 09-11-2012, 02:23 PM

In what column is the due date?

**irismarcial** · 09-11-2012, 03:41 PM

Originally Posted by ChemistB

In what column is the due date?

There is a total of 30days between the date in column F to N...each date between those are the due dates

So if for say...the due date in J61 is pass due by 3 days from the date in that cell...then I want it to turn red

**ChemistB** · 09-11-2012, 04:03 PM

Okay, so in G33, for example, it's 8/6/12. That is the date that you are due to send it to the PM. Correct? So on 8/9/12, if you did not send it, it should turn red, correct again?
How does Excel know if you sent it or not?

**irismarcial** · 09-11-2012, 04:18 PM

Originally Posted by ChemistB

Okay, so in G33, for example, it's 8/6/12. That is the date that you are due to send it to the PM. Correct? So on 8/9/12, if you did not send it, it should turn red, correct again?
How does Excel know if you sent it or not?

No the date in J33 is the the due date pay no attention to g column. so if I didn't send it to the pm by H33 ex..8/6/2012 i want it to turn red if i go pass this date of 8/6/2012 by 2 days.