Forum Discussion

JHailo1415's avatar
JHailo1415
Copper Contributor
Jan 13, 2023

Conditional Formatting based on data in one cell using today function

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!

Resources