Hi!
So, i would like to have my spreadsheet to change colors after a certain time has elasped from a date in another cell.
This is to make it easier to follow up with my customers after certain days.
Here is what i have:
Quoted Date Follow up date
Jan 23 / 2012(A2) (B2)
Feb 21 / 2012(A3) (B3)
March 02 / 2012(A4) (B4)
Could someone please help me with the Conditional Formating formula to make my cell rows A2-F2.. etc to change colors depending on todays date..
7 Days - Turn Green
14 Days - Turn Yellow
30 Days - Turn Red
Please advise
Thanks!
Bookmarks