Need rule help

New Contributor
Is there a rule to high light columns (ex. E and F) based on the value of column H.

In this case E and F are first and last names that I would like high lighted yellow based on the word yes in column H.
3 Replies


It seems to work in my spreadsheet, see attached file.

Which rule did you use?


The rule is also shown in the attachment of my last post.