ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Format Formula to color row based on text (https://www.excelbanter.com/excel-programming/441504-conditional-format-formula-color-row-based-text.html)

Steve McPheters

Conditional Format Formula to color row based on text
 
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.




All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com