Forum Discussion
Solved
AND Formula not Working
Hello, I am working on a Gantt chart style calendar which will show when a promotion is running. I am using an AND function to pull this information through via Conditional Formatting. On a small...
Make sure that L17 is the active cell in the selection when you create the rule with formula
=AND(L$16>=$H17,L$11<=$I17)
Otherwise, Excel will change the formula.
Make sure that L17 is the active cell in the selection when you create the rule with formula
=AND(L$16>=$H17,L$11<=$I17)
Otherwise, Excel will change the formula.
- That worked. Thanks so much!
