HI
I posted this in the Excel formula section and it was solved quickly. The problem is that i did not know I cannot use those formulas and conditional formatting in google sheets...or i am not putting it in right. I see in google sheets there are date options, but non of them seem to fit my needs.
What i need is:
Formulas for 3 columns on my spreadsheet. I need a formula that changes red when the date inside it is 3 years older than today’s date, but stays green when not. It also needs to change red when there is no date. When I say today, I mean when I open it on the February 23rd that’s “today's” date, or if I open it on March 12th, that’s today's date, etc.
I am pretty new to Excel and see all the really awesome things you can do with it, it’s just sometimes I don’t know how to do it. I tried looking up a formula using today() and IF but I am not sure how to put the formula(s) together. I also need one that changes at the one year mark, but I figure I can just change the number in the formula for the one above?
Any help would be greatly appreciated!!
Capture.PNG
Bookmarks