Hey guys,
I'm trying to set up a 3-colour scale for a column of dates. I need the following criteria to apply:
Cells turn green if date is within the past 0 - 30 days
Cells turn yellow if date is within the past 30 - 40 days
Cells turn red if the date is past 40 days
I thought that I could set this up using a formula for each but I am not sure what I would input in particular. Do you know how I would do that?
I've attached an image to show my current thinking.
Any help would be really great!
Thanks - Amba
Screenshot 2019-11-23 at 10.09.04.png
Bookmarks