Conditional Formatting based on data in one cell using today function

Occasional Visitor

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!Screen Shot 2023-01-12 at 8.11.32 PM.png

1 Reply


As additional information to do it yourself

Example file included


Formula for conditional formatting:



Hope I was able to help you with this info.



I know I don't know anything (Socrates)