Hi Everyone

help appreciated, I am trying to format a date column to highlight if the date is

Between 2 days & 14 days old (from today()) Green
between 14 & 24 days Amber
between 25 & 31 days red
over 31 days no format


Here is the formula I have tried i do not think this is correct or the most efficient

Formula: copy to clipboard 
=AND($A10>=TODAY()+25,$A11>=TODAY()-31)
should be red
Formula: copy to clipboard 
=AND($A10>=TODAY()+15,$A10>=TODAY()-24)
should be amber

etc

This is in order to highlight target date ranges.

Thank you in advance.

Kelly