Good Evening/Morning
I am lookking for a formula or condition formatting for a date i want to put in todays date and then it must de highlighted in yellow for 2 months after which te formatting must disapear all my dates are in one collum each in there own cell i type in the new date in the same cell in other words just replacing the old date but then the new date must be the one that is highligted in yellow
04-Oct-12
05-Oct-12
05-Dec-12
07-Jun-12
22-Feb-12
12-Jan-12
29-Nov-12
06-Oct-12
20-Dec-12
03-Dec-12
07-Jan-13
04-Sep-12
15-May-12
31-Jul-12
21-Sep-12
22-Feb-13
27-Feb-12
10-Oct-12
04-Feb-13
12-Dec-12
04-Nov-12
24-Oct-12
02-Nov-12
10-Jan-13
06-Dec-12
Bookmarks