Nov 21 2021 09:02 AM
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..???
Nov 21 2021 09:22 AM
Solution=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.
Nov 21 2021 09:40 AM
Nov 21 2021 09:22 AM
Solution=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.