If C2 = 21/06/14
I need F2 to highlight when 60 days have passed from the date entered in C2
thanks
sorry might have got it. Would this work if placed in F2 =C2+60<TODAY()
No access to excel at the minute to try it
If C2 = 21/06/14
I need F2 to highlight when 60 days have passed from the date entered in C2
thanks
sorry might have got it. Would this work if placed in F2 =C2+60<TODAY()
No access to excel at the minute to try it
Last edited by Davycc; 08-20-2014 at 04:51 PM.
There are a couple of ways to do this - entering your formula into F2 will show TRUE or FALSE. Alternatively, if you create a conditional format, based on your formula =C2+60<TODAY(), in cell F2 (or any other cell you want, including C2) you will be able to apply a different format (eg coloured background) when the 60 days have passed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks