Conditional formatting for changing column color if between more than 7 days and less than 10 days

[Jyotirmaya]

I am using formula in conditional formatting to highlight cells of date which is of lesser than 7 days of Today's date.

=AND(E:E<TODAY(),E:E<(TODAY()-7))

I want a formula that it should highlight the color of dates which is of more than 7 days and and less than or equal to 10 days which will highlight a different color and another formula if the date is more than 10 days then a different color. Kindly help with the formula

 

[etaf]

dates which is of more than 7 days and and less than or equal to 10 days

AND( E1<Today()-7, E1>=Today()-10)

date is more than 10 days then a different color.

=AND(E1<today()-10,E1<>"")
As a blank cell is seen as blank 0 and excel thinks this is Jan 1900
So the
E1<>""
Checks to make sure the cell is NOT blank

 

[Jyotirmaya]

AND( E1<Today()-7, E1>=Today()-10)

=AND(E1<today()-10,E1<>"")
As a blank cell is seen as blank 0 and excel thinks this is Jan 1900
So the
E1<>""
Checks to make sure the cell is NOT blank

Thank you so much

 

[etaf]

you are welcome