What I'm trying to do is check if "C" column "Required" is yes and only then, check if "B" column "Status" is "Empty", then fill "B" column in red.
What I've tried: =AND(C5="Yes";B5="Empty")
I put 5 cause my table starts at that specific row, but it changes row number ok.
But it doesn't work, it fills in red another row, understandable.
Can you help me? Thanks!
Bookmarks