Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help using Conditional Formating of Entire Rows
Need help with conditional formating entire rows using a veriable.
While I understand you can format an entire row by using something like... Formula =$A1="Total" I'm trying to go one step beyond that and automaticly format any row that "contains" a certain word, such as highlighting any row that contains the word total (Sales Totals or Department Total or Corporate Total). For example I have a table of Sales by Department for our company. I run a macro that SUBTOTALS the sheet by department. Now I have a list of sales data with seven or eight subtotals by department. And I have now gone over my limit of three conditions. So I can not just make a condition for each Department Total. I have to figure out how to conditionaly format any row that might contain the the word total as part of the text of the cell. Any ideas? Thanks for all the help Steve Monczka |
#2
|
|||
|
|||
Hi
try =COUNTIF(1:1,"*Total*")=1 Cheers JulieD wrote in message oups.com... Need help with conditional formating entire rows using a veriable. While I understand you can format an entire row by using something like... Formula =$A1="Total" I'm trying to go one step beyond that and automaticly format any row that "contains" a certain word, such as highlighting any row that contains the word total (Sales Totals or Department Total or Corporate Total). For example I have a table of Sales by Department for our company. I run a macro that SUBTOTALS the sheet by department. Now I have a list of sales data with seven or eight subtotals by department. And I have now gone over my limit of three conditions. So I can not just make a condition for each Department Total. I have to figure out how to conditionaly format any row that might contain the the word total as part of the text of the cell. Any ideas? Thanks for all the help Steve Monczka |
#3
|
|||
|
|||
Try:
=COUNTIF(1:1,"*total*") HTH Jason Atlanta, GA -----Original Message----- Need help with conditional formating entire rows using a veriable. While I understand you can format an entire row by using something like... Formula =$A1="Total" I'm trying to go one step beyond that and automaticly format any row that "contains" a certain word, such as highlighting any row that contains the word total (Sales Totals or Department Total or Corporate Total). For example I have a table of Sales by Department for our company. I run a macro that SUBTOTALS the sheet by department. Now I have a list of sales data with seven or eight subtotals by department. And I have now gone over my limit of three conditions. So I can not just make a condition for each Department Total. I have to figure out how to conditionaly format any row that might contain the the word total as part of the text of the cell. Any ideas? Thanks for all the help Steve Monczka . |
#4
|
|||
|
|||
Thank you both for such a quick responce. That totaly did the trick.
Thanks again. Steve |
#5
|
|||
|
|||
you're welcome and thanks for the feedback
wrote in message oups.com... Thank you both for such a quick responce. That totaly did the trick. Thanks again. Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
How to change an entire row using conditional formating | Excel Discussion (Misc queries) | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |