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)
