Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
Jason Morin
 
Posts: n/a
Default

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   Report Post  
 
Posts: n/a
Default

Thank you both for such a quick responce. That totaly did the trick.

Thanks again.

Steve

  #5   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 10:12 PM
Using PROPER for Columns, rows or ENTIRE spreadsheet Tom Excel Worksheet Functions 3 February 4th 05 04:43 PM
How to change an entire row using conditional formating John Edwards Excel Discussion (Misc queries) 2 December 9th 04 06:41 PM
30 Day Aging Report Using Conditional Formating Tiegris Excel Worksheet Functions 0 November 4th 04 11:07 PM
How do I use conditional formatting for multiple rows? Jim Johnson Excel Worksheet Functions 1 October 30th 04 03:36 AM


All times are GMT +1. The time now is 08:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"