Hello
I need a row to change colour if column G contains either "example1" or "example2" BUT only if column AD is NOT BLANK
At the moment I have 2 separate conditions:
=$G2="example1"
=$G2="example2"
I know that =NOT(ISBLANK($AD2)) will also work on it's own I just don't know how to combine the 3 in conditional formatting?
Please help
Thanks
Bookmarks