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.
=AND($E2="Tech Spec: Svc: Evaluate",$F2>=10,$F2<=20)
Add the "=" sign. Instead of "$F2>10" add "$F2>=10", so the result will be different for value "10".
Add the "=" sign. Instead of "$F2>10" add "$F2>=10", so the result will be different for value "10".