Contitional Format SubTotal Line
 

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

Contitional Format SubTotal Line
 

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)

"Cathy" wrote in message
...
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

Contitional Format SubTotal Line
 

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

"Bob Phillips" wrote:

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)

"Cathy" wrote in message
...
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

Contitional Format SubTotal Line
 

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


In article ,
Cathy wrote:

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

"Bob Phillips" wrote:

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)

"Cathy" wrote in message
...
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

Contitional Format SubTotal Line
 

You are awesome! Thank you so much.

That is exactly what I was looking for.

Cathy