Conditional Formatting - Highlighting a row with multiple criteria

New Contributor

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 Replies

@chwar750 Use something like this:

 

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

Amazing thank you!!

Worked a charm