Prev: Using Object & Worksheet names as variables
Next: Deleting Lines
From: Steve McPheters on 9 Apr 2010 14:30
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.


 | 
Pages: 1
Prev: Using Object & Worksheet names as variables
Next: Deleting Lines