Highlight Row if cells in two adjacent columns contain the text Yes

[Marie6517]

Hi everyone,

I would like to highlight the rows in my spreadsheet where columns G and H both contain the text "Yes". Any help would be great I've tried conditional formatting and VBA but can't seem to get either to work for what I need.

Thank you!

 

[bbott]

Conditionally format cell A1 with this formula:

=AND($G1="Yes",$H1="Yes")

Select your formatting.
Copy formatting accross row.
Copy formatting of row down as needed.

 

[Marie6517]

Thanks! this worked perfectly

 

[bbott]

You're welcome, glad it works.