Try This:

FormatConditional Formatting

Conditions:
1st: Cell Value Is
2nd: equal to
3rd: ="Employee"
[Select Format button and choose yellow formatting for cell)
OK




"Sherry" wrote:

For every row that contains the word "employee", I want to color as yellow.
I know conditional formatting is what I should use but need help.

Thanks!