Excel 97 Subtotals Formatting

  • Thread starter Thread starter Stephen R.
  • Start date Start date
S

Stephen R.

I understand 97 has a shortcoming in bolding data in the
Subtotals row. I want to bold these rows as well as
format the cell's shading (A:Q & S only)in a light gray
for easier reading. Is there a sub I can run? Was there
ever an MS "fix" for this? I have SR-1.
 
Hi
no need for a sub/macro. Try the following:
- select for example cells A1:C100
- goto 'Format - Conditional Format'
- enter the following formula
=ISNUMBER(SEARCH("total",$A1))
- choose your format for the subtotal rows
 
No go on this one so far. I ran the Subtotals step,
selected A1:Q450, and performed your directions.
 
Back
Top