Hello, Guru's - thank you for being so amazing. Searched everywhere for this conditional formatting formula on youtube - I can't seem to nail it down. Heres the deal.


I have a column of varied dates.



I want to know
If greater than 365 days from cell date but less than 547 days (one color)
then in that same column
If greater than 547 days but less than 730 days (another color)

Basically, I have a column of peoples names who have started a program, and then in the next column, I have a list of the dates they started the program. There are milestones when they've been around for a year and then another one when they've been around for 18 months. I might even like to add one for if they've been around for over two years. I would then like to re-order the list in chronological order, but there are many other columns involved with insurance, SS# etc which makes me nervous. Thanks!