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.
Thanks for all the responses. I think I was circling the solution and I wasn't googling the right question.
I finally got it to work with formula looking like this:
=IF(AND($E1="Tech Spec: Svc: Evaluate",$F1>10,$F1<=20),"True","False")
Turns out the IF and the True and False were needed for the formula to work.
I finally got it to work with formula looking like this:
=IF(AND($E1="Tech Spec: Svc: Evaluate",$F1>10,$F1<=20),"True","False")
Turns out the IF and the True and False were needed for the formula to work.
That IF should NOT be needed. I'm really curious why it didn't work without it. Another thing you can try is using * instead of AND like this:
=($E1="Tech Spec: Svc: Evaluate")*($F1>10)*($F1<=20)
=($E1="Tech Spec: Svc: Evaluate")*($F1>10)*($F1<=20)