Formula/Solution/Setup

[ana2006bal]

Okay, the table below is an example of what I need but not sure how to write the formula/what setup would be best.

I am trying to figure out the best way to make the status column work correctly. For each row:
if Date 1 is 1 day or less before Date 2 = Red Status
if Date 1 is between 2 day and 7 days before Date 2 = Yellow Status
if Date 1 is greater than or equal to 8 days before date 2 = Green Status

Date 1	Date 2	Status
1/20/22	1/21/22	Red
1/18/22	1/21/22	Yellow
1/13/22	1/21/22	Green

I was looking at conditional formatting but didn't know if there was a formula or if setting up rules would be best?

Thanks for your input!

 

[Joe4]

Welcome to the Board!

So, if your data above is in the range A1:C4 (where row is the header), here are the three Conditional Formatting Rules (formulas) to set up: