Conditional Formatting - Highlighting a row with multiple criteria

[chwar750]

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

[#2 · Accepted solution]

@chwar750 Use something like this:

=AND($N1="Yes",NOT(ISBLANK($O1)))

[#3]

Amazing thank you!!

Worked a charm