Well, I need a little help here and tought you guys could help. I am using Excel 2007. I have my B row full of dates for item I need to turn in. I would like the cell to turn green when that date is in the current month and Red when it goes past the date in the cell.
Example:
B2 22-Apr-09
That cell should be Green because we are in April right now. It should turn red once it goes past the 22nd telling me it is late.
Thank you for your help and time.
Example:
B2 22-Apr-09
That cell should be Green because we are in April right now. It should turn red once it goes past the 22nd telling me it is late.
Thank you for your help and time.