Forum Discussion

Copper Contributor

Oct 26, 2021

Solved

Conditional Formatting - Highlighting a row with multiple criteria

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

excel

Formulas and Functions

office 365

Riny_van_Eekelen
Oct 26, 2021
chwar750 Use something like this:

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

Riny_van_Eekelen

Platinum Contributor

Oct 26, 2021

chwar750 Use something like this:

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

chwar750

Copper Contributor

Oct 26, 2021

Amazing thank you!!

Worked a charm