Question related to Conditional Formatting

[Excel]

Hello Everyone,

Can you please show with example of Conditional formatting - 

 Let's say 7 days away in red, less than 1 month in yellow and less than 1.5 months in light blue?

So what formula should i write in Conditional Formatting?

Please help..???

[#2 · Accepted solution]

@Excel 

=IF(A3<=TODAY()+7,TRUE,"")

=IF(AND(A3>TODAY()+7,A3<TODAY()+30),TRUE,"")

=IF(AND(A3>=TODAY()+30,A3<TODAY()+45),TRUE,"")

You need 3 different rules for conditional formatting as shown in attached file.

[#3]

Thank you so much sir. It helps me a lot.