Have you looked into Conditional Formatting ?
"Slickwillie" wrote in message
...
After creating subtotals, I would like excel to automatically hightlight
the
subtotal row in a different cell shading. Is this possible? If yes, How?

After you applied data|subtotals, you'll see Total (or Count or Average or...)
in the field that you subtotaled by.

In my test data, I subtotaled using Sum, so I saw Total in that column (and in
my test, I used Column A).

Then I selected my range (all the subtotal range is ok) and did
Format|Conditional formatting

Then I used:
Formula is:
=COUNTIF($A2,"*total*")0
(My active cell was in Row 2 and column A held that "xxxxx Total" info.)

And gave it a nice format.



Slickwillie wrote:

Yes, I experimented with Conditional formation but could not figure out a way
to automatically shade the entire row based on a formula or cell content.

I did read a post in here that helped. After creating the subtotal I clicked
on the "2" in the upper left corner to select just the Subtotal rows. Then
clicked EditGoTo can checked "visible only" after that I just clicked the
shading button on the toolbar. It's not automated but much closer than I was
before.
Thanks anyway

"Corey" wrote:

Have you looked into Conditional Formatting ?
"Slickwillie" wrote in message
...
After creating subtotals, I would like excel to automatically hightlight
the
subtotal row in a different cell shading. Is this possible? If yes, How?




--

Dave Peterson

In a similar fashion as Dave - I did the usual Sub-total "thing"
A B C D E
1 Order PRDate Dept PhanSeg CoShare
2 100 3062004 41701234 00 123.00
3 41701234 Total 123.00 << Created By S/T
4 50 3062004 41701345 00 321.00
5 60 3062004 41701345 02 843.00
6 150 3062004 41701345 01 543.00
7 41701345 Total 1,707.00 << Created By S/T
8 160 3062004 41701500 00 347.00
9 41701500 Total 347.00 << Created By S/T

I then Clicked on the Row Header of Row 2 - then Format, CF, FormulaIs
and entered:

=IF(ISNUMBER(FIND("Total",$C2)),TRUE)
Chose a pattern (color).
OK, out

Then again selected Row Header of Row 2 - Clicked on the Toolbar Icon
Paint-Brush - Clicked on Row Header 3 and drug down to final row.

Only my "Total" rows were painted !!

Good Luck,

Jim May


" wrote in message
:

After you applied data|subtotals, you'll see Total (or Count or Average or...)
in the field that you subtotaled by.

In my test data, I subtotaled using Sum, so I saw Total in that column (and in
my test, I used Column A).

Then I selected my range (all the subtotal range is ok) and did
Format|Conditional formatting

Then I used:
Formula is:
=COUNTIF($A2,"*total*")0
(My active cell was in Row 2 and column A held that "xxxxx Total" info.)

And gave it a nice format.



Slickwillie wrote:

Yes, I experimented with Conditional formation but could not figure out a way
to automatically shade the entire row based on a formula or cell content.

I did read a post in here that helped. After creating the subtotal I clicked
on the "2" in the upper left corner to select just the Subtotal rows. Then
clicked EditGoTo can checked "visible only" after that I just clicked the
shading button on the toolbar. It's not automated but much closer than I was
before.
Thanks anyway

"Corey" wrote:

Have you looked into Conditional Formatting ?
"Slickwillie" wrote in message
...
After creating subtotals, I would like excel to automatically hightlight
the
subtotal row in a different cell shading. Is this possible? If yes, How?




--

Dave Peterson