Contitional Format SubTotal Line

[Guest]

I need to bold my sub-totals rows. My spreadsheet is generated from ACCESS
and the number of rows between subtotals is not constant. I'm trying to
figure out if there is a way to use conditional formatting to product the
desired result. Each subtotal row is labeled as "Sub-Total as of
XX/XX/XXXX". How would I set up this conditional format?

If conditional format won't work, is there another way to accomplish this?

Thank you!
Cathy

 

[Bob Phillips]

Select all of the cells, and in CF, use formula of

=LEFT(A1,9)="Sub-Total"

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Bob,

That works perfectly to make the first column bold. Is there a way to make
the entire row bold?

Thank you so much,
Cathy

 

[JE McGimpsey]

Select the entire sheet (or all the cells you want to bold), with a cell
in row 1 as the active cell, and use

CF1: Formula is =LEFT($A1,9)="Sub-Total"
Format1: <font>/<bold>

 

[Guest]

You are awesome! Thank you so much.

That is exactly what I was looking for.

Cathy