VBA to highlight row with value in it

[cmccabe]

The code below works great, but it only highlights the cells. I can not seem to change it correctly to highlight the row. Thank you.

For example,

In row 2 the clinvar column value is pathogenic so the classification column is pathogenic and the entire row is highlighted dark red.
In row 3 the clinvar column value is unknown so the classification column is uncertain significance and the row is highlighted yellow.

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[cmccabe]

Thank you very much.

[Mumps1]

My pleasure.