I'm trying to create a "comments" field in a worksheet for error-checkers that can only be used when certain errors are flagged as present. (by writing a whole number in the relevant cell)
I've tried a number of permutations but they all give an error no matter what state the referenced cells are in.
AND(NOT(ISBLANK(S3)),NOT(ISBLANK(W3))) as custom data validation, with and without "Ignore blanks" checked.
Am I missing something? Is this not possible without VBA? (Ideally I don't want to have to make my collegues click on macros every week)