Oct 26 2021 04:29 AM
Hi,
I'm trying to Highlight a row with multiple criteria.
Normally I would use something along the lines of...
=AND($A3="Yes",$B3="YES")
But in this instance I need the second value to just be a non-blank cell and the formula for this doesn't seem compatible or I'm just not quite getting it.
I need column N to read yes and column Q to be filled (with anything) to highlight the full row.
Any help would be appreciated!!
Oct 26 2021 04:37 AM
SolutionOct 26 2021 05:01 AM
Oct 26 2021 04:37 AM
Solution