Question on Subtotal Function

D

Daniell

I am using the Subtotal function and it works good. Is it possible to high
light the numeric figure. What it does it high lights the word TOTAL but
not the numeric amount. Also is there a way to insert a line after the last
Subtotal operation automatically? Thanks in advance for you help.
 
F

Frank Kabel

Hi
try:
- select A1:B100 (adapt to your data layout)
- goto 'Format - Conditonal format
- enter the following formula:
=ISNUMBER(SEARCH("total",$A1))
- choose a format
 
Top