Forum Discussion
Solved
Conditional Formatting in a Macro with AND statement
I have been struggling to get Conditional Formatting to work using the following type of formula: =AND($E2="Tech Spec: Svc: Evaluate",$F2>10,$F2<=20) I would like to format the cell in column...
Your rule for conditional formatting works perfectly in my sheet.
the AND statement should work just fine. Just know/remember that the custom formula in the conditional formatting rule must be correct when applied to the upper left cell of the Applied To range set for that conditional formatting rule. Then using the $ on the aspects that should be locked (as it appears you have already done). So basically I would make sure the Applied To range is F2:Fsomething