Conditional Formatting - Highlighting a row with multiple criteria

Question

Hi,&nbsp;I'm trying to Highlight a row with multiple criteria.&nbsp;Normally I would use something along the lines of...=AND($A3="Yes",$B3="YES")&nbsp;&nbsp;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.&nbsp;I need column N to read yes and column Q to be filled (with anything) to highlight the full row.&nbsp;&nbsp;Any help would be appreciated!!&nbsp;

riny_van_eekelen · Accepted Answer

chwar750&nbsp;Use something like this:&nbsp;=AND($N1="Yes",NOT(ISBLANK($O1)))

Forum Discussion

Conditional Formatting - Highlighting a row with multiple criteria

2 Replies

Resources