PC Review


Reply
Thread Tools Rate Thread

Conditional Format Formula to color row based on text

 
 
Steve McPheters
Guest
Posts: n/a
 
      9th Apr 2010
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.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format stoplight based on worst color Morgimo Microsoft Excel Worksheet Functions 3 21st Jul 2009 11:28 PM
Conditional format a cell based on color of another Marlo Microsoft Excel Misc 3 21st Jan 2008 01:50 AM
Conditional format: change row color based on cell value Carelle Microsoft Excel Misc 2 3rd Jan 2008 09:26 PM
Conditional color based on formula in cell Ron Gommers Microsoft Excel Worksheet Functions 1 12th Nov 2003 02:00 PM
Conditional format: if formula result is #N/A then make text color white? How? Keith R Microsoft Excel Misc 2 25th Jul 2003 03:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:28 AM.