From: Steve McPheters on
I have reports showing internet usage for various employees.

I have been asked to print these out and highlight the places the employees
shouldn't be during working hours.

I have searched looking for a example macro that might do this with out
results. I have found that most people recommend Conditional Formatting to
do this. I have looked for formula examples to change the color of a row. I
can't find a example that will look for text. Could someone give me a
example of a formula that will change the background color of a row
depending on text in a cell on the row.