SOLVED

Question related to Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2990587%22%20slang%3D%22en-US%22%3EQuestion%20related%20to%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2990587%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3ECan%20you%20please%20show%20with%20example%20of%20Conditional%20formatting%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3BLet's%20say%207%20days%20away%20in%20red%2C%20less%20than%201%20month%20in%20yellow%20and%20less%20than%201.5%20months%20in%20light%20blue%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20what%20formula%20should%20i%20write%20in%20Conditional%20Formatting%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20help..%3F%3F%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2990587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2990622%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2990622%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(A3%26lt%3B%3DTODAY()%2B7%2CTRUE%2C%22%22)%3C%2FP%3E%3CP%3E%3DIF(AND(A3%26gt%3BTODAY()%2B7%2CA3%3CTODAY%3E%3C%2FTODAY%3E%3C%2FP%3E%3CP%3E%3DIF(AND(A3%26gt%3B%3DTODAY()%2B30%2CA3%3CTODAY%3E%3C%2FTODAY%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%203%20different%20rules%20for%20conditional%20formatting%20as%20shown%20in%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2990633%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2990633%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20sir.%20It%20helps%20me%20a%20lot.%3C%2FLINGO-BODY%3E
Regular Contributor

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 Replies
best response confirmed by Zan_Hanifee (Regular Contributor)
Solution

@Zan_Hanifee 

=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.

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