Forum Discussion
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, test data set, it is working fine; however, when I transfer the formula to my actual data set of several thousand lines, it is not working.
TEST SET:
The formula is entered as =AND(L$16>=$H17, L$16<=$I17) but the formula itself seems to change in the Conditional Formatter and does not pull through as it should:
Is anyone able to assist?
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.
2 Replies
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!
