This might be a simple answer but... if A1 had the date 1-Jan-2010, what formula would I used, within conditional formatting, to make that cell turn blue once 90 has passed? So the cell should turn blue on 1-Apr-2010.
Thanks in advance.
Michelle
This might be a simple answer but... if A1 had the date 1-Jan-2010, what formula would I used, within conditional formatting, to make that cell turn blue once 90 has passed? So the cell should turn blue on 1-Apr-2010.
Thanks in advance.
Michelle
Last edited by Michelle2175; 01-19-2010 at 02:01 PM.
Use formula
=(INT(A1)+90=INT(today()))
test it using =(INT(A1)+90=INT(DATE(2010,4,1)))
Last edited by rwgrietveld; 01-19-2010 at 12:51 PM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Try:
=Today()>=A1+90
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Okay NBVC... I got another question for you
Let's say...A1 had the date 1-Jan-2010 and again if I wanted it to turn blue after 90 days, then I would use your formula above.
BUT... once I enter a date into B1, then A1 would automatically go back to no fill.
How do I do that?
Thanks!
Michelle
Last edited by Michelle2175; 01-19-2010 at 01:30 PM.
Try
=AND(Today()>=A1+90,B2="")
Okay just one more... I promise.
What if some rows in column A do not have a date... how do I stop those cells from turning blue as well???
maybe
=AND(A1<>"",Today()>=A1+90,B1="")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks