Sep 28 2021 02:03 PM
Good morning,
Trying to create a conditional formatting rule, that if:
Cell B6 is NOTBLANK but Cell L6:N6 is BLANK if should highlight the cells.
I've tried different forumlas, but unable to use & as its a conditional formula rule.
Any idea's, or something I'm missing?
Thanks.
Sep 28 2021 02:15 PM
SolutionSep 28 2021 02:15 PM
Solution