miteshshah
New Member
I have a cell with a particular date (i.e. 08/20/12).
If the current date is three (3) days prior to 08/20/12, I would like the cell to turn red.
If the current date is five (5) days prior to 08/20/12, I would like the cell to turn yellow.
I need this done for an entire column in Excel 2010. I do not know VBA, so can someone help me without being too advanced?
If the current date is three (3) days prior to 08/20/12, I would like the cell to turn red.
If the current date is five (5) days prior to 08/20/12, I would like the cell to turn yellow.
I need this done for an entire column in Excel 2010. I do not know VBA, so can someone help me without being too advanced?
