Conditional Formatting - Highlighting a row with multiple criteria

New Contributor



I'm trying to Highlight a row with multiple criteria.


Normally I would use something along the lines of...



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!!


2 Replies

@chwar750 Use something like this:



Amazing thank you!!

Worked a charm