ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   would like each subtotal line highlighted (https://www.excelbanter.com/excel-discussion-misc-queries/137092-would-like-each-subtotal-line-highlighted.html)

SJS

would like each subtotal line highlighted
 
I have subtotaled a a/p list and would like the have each subtotal line
highlighted

Jim Thomlinson

would like each subtotal line highlighted
 
Have you looked at Format - Auto Format... It usually does a nice job of
formatting sub-totals.
--
HTH...

Jim Thomlinson


"sjs" wrote:

I have subtotaled a a/p list and would like the have each subtotal line
highlighted


Dave Peterson

would like each subtotal line highlighted
 
Apply the data|Subtotals
Use the outlining symbols to the left to hide the details
select the range to modify
Edit|goto|special|visible cells only

apply the formatting you like to those visible cells

Then show all the range???

sjs wrote:

I have subtotaled a a/p list and would like the have each subtotal line
highlighted


--

Dave Peterson


All times are GMT +1. The time now is 05:27 PM.

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