Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 4th 06, 04:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default How can I color only subtotal lines in Excel 2002?

I believe 2003 has this abiltiy; is there a macro that will facilitate the
selection and formatting of the subtotal likes themselves, and not the lines
of the list that is subtotaled?

  #2   Report Post  
Old October 4th 06, 05:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default How can I color only subtotal lines in Excel 2002?

You can apply an auto format using Format - AutoFormat (don't do this on
list over 10,000 rows as it is painfully slow). If the list is over 10,000
the use a pivot table...
--
HTH...

Jim Thomlinson


"dfw in NJ" wrote:

I believe 2003 has this abiltiy; is there a macro that will facilitate the
selection and formatting of the subtotal likes themselves, and not the lines
of the list that is subtotaled?

  #3   Report Post  
Old October 4th 06, 05:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 510
Default How can I color only subtotal lines in Excel 2002?

Hi Jim,

Based on what differentiates these lines have a go with Conditional
Formatting ...

HTH
Cheers
Carim

  #4   Report Post  
Old October 5th 06, 03:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default How can I color only subtotal lines in Excel 2002?

Jim: Thanks for the suggestion.

Using the lists in autoformat provides a solution.

I guess I have to go to conditional formatting (see Carim's suggestion) if
I want to change the color of the font..????

dfw

"Jim Thomlinson" wrote:

You can apply an auto format using Format - AutoFormat (don't do this on
list over 10,000 rows as it is painfully slow). If the list is over 10,000
the use a pivot table...
--
HTH...

Jim Thomlinson


"dfw in NJ" wrote:

I believe 2003 has this abiltiy; is there a macro that will facilitate the
selection and formatting of the subtotal likes themselves, and not the lines
of the list that is subtotaled?

  #5   Report Post  
Old October 5th 06, 03:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 510
Default How can I color only subtotal lines in Excel 2002?

Hi,


Example of an event macro which colors 5 cells to its right if the word
"Subtotal" is entered in the reference range A1:A10 ... Adjust to
your needs

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:A10")) Is Nothing Then
Exit Sub
Else
If Target.Value = "Subtotal" Then
Target.Offset(0, 1).Range("A1:E1").Interior.ColorIndex = 6
End If
End If
End Sub

HTH
Cheers
Carim



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
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
Can I automatically extend formulas to added lines in Excel 2002? BillyV Excel Discussion (Misc queries) 5 March 1st 06 07:51 PM
hyperlinks not working in excel 2002 SP3 Roundy Excel Discussion (Misc queries) 0 July 7th 05 09:40 PM
Excel XP 2002 Vs. Excel 2000 Samantha Excel Discussion (Misc queries) 0 April 18th 05 03:54 PM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 03:44 AM


All times are GMT +1. The time now is 01:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017