Excel 97 Subtotals Formatting

[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.

 

[Frank Kabel]

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

 

[Stephen R.]

No go on this one so far. I ran the Subtotals step,
selected A1:Q450, and performed your directions.