Hi all,
I'm currently making a data analysis spreadsheet for my work and I'm trying to conditionally format cells based on what time of year it is.
So for example, if a student has a grade ELG in cell A2 and today's date is between Sept 1st and Oct 20th (year isn't important) then the cell highlights bright green, but if the same student has the same grade between Jan 1st and Feb 19th then the cell highlights light green.
This is how my table looks currently:
Attachment 605846
Thanks for any and all help
Bookmarks