Help with creating a tracker

Question

I have a column with names and two other columns with start dates and end dates ranging a 6 month period. I want to create a condition that will change the color of the individuals name (Green = Before start of date range, Yellow = 4 months from start date, Orange = 5 months from start date, Red = 6 months from start date). Each individual has a different set of start/end dates for their 6 month period and would like every name to function the same way.

Answer 1

Thank you so much! That saved my headache, I appreciate your time.

Answer 2

Let's say the names are in A2:A50 and the start dates in D2:D50.

Select A2:A50. A2 should be the active cell in the selection.

Set the fill color to green. This will be the default.

On the home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=D2<=TODAY()

Click Format...

Activate the Fill tab.

Select yellow.

Click OK, then click OK again.

Repeat these steps, but with

=D2<=EDATE(TODAY(),-4)

and orange.

Finally, repeat them with

=D2<=EDATE(TODAY(),-5)

and red.