Hello all!
I am trying to make a school calendar for myself and was wondering if anyone could help me figure this out. In this calendar, I have it set up so the dates are listed in Column A, with each date taking a separate row. Column's B-H have each subject listed individually and also go down the rows corresponding with each date. I am trying to figure out how to use conditional formatting to:
1) Make a rule that each row with a date in it that is before todays date will turn green
2) Make a rule that each row with Today's date in it will turn red
3) Make a rule that each row with a date occurring up to 7 days after today's date will turn orange.
It would be a huge help if anyone could add their input, thank you!
