Conditional Formatting multiple criteria date based

[Sharpedge]

I inherited a spreadsheet and the condtional formatting is not working. Using Excel 2016

The formula used is AND(A1>0,Today()-A1>=1,Today()-A1>=1)
The next line is AND(A1>0,Today()-A1>=1,Today()-A1>=2)
The next line is AND(A1>0,Today()-A1>=1,Today()-A1>=3)
The next line is AND(A1>0,Today()-A1>=1,Today()-A1>=4)

What is suppose to happen as the date gets closer to today the cell changes colors from Green for >=4 to red when >=1.

I have played with the order and still can't get it right and it seems to me there should be an easier way.

Any help is appreciated.

 

[Fluff]

In what way isn't it working?

 

[Sharpedge]

Apologies, there is no formatting applied, the cell has no color.

Thank you for looking at my question.

 

[Fluff]

Ok a few questions
1) Does your data start in A1?
2) what is the "applies to range"
3) Are you dates real dates or text, select col A & format to "General" what do you see?

 

[Sharpedge]

My data starts in H23
The applied to is $H$23:$H$162
H23 is formatted as a Date, but the cell has the following formula in it: Workday(G23,5,$B$2:$B$14)
Also while checking the applied to range I discovered I left off another conditional format rule And(I23<>"C",H23<Today()
Cell I23 can have C for completed, or A for approved, or O
$B$2:$B$14 are for the holidays (Christmas, New Years, etc.)

 

[Fluff]

For red try
=AND(H23>0,TODAY()-H23>=1)
and then change the >=1 to 2 then 3 etc for each colour

 

[Sharpedge]

Thank you for your assistance. I made those changes and the cells still have no color.

I reviewed the information I gave you and it is correct. I checked to make sure I hadn't failed to tell you something.
Again i appreciate you taking the time.

 

[Fluff]

In that case I'm not sure what the problem is.
Would you be willing to share your workbook, by uploading it a share site & posting a link here?

 

[Sharpedge]

Another associate finally came up with a solution that worked.

Thank you again for your help and looking at my post.

 

[Fluff]

Glad it's sorted & thanks for the feedback