I'm trying to make bold the subtotals in my spreadsheet I created via
DataSubtotal... using a formula in Conditional Formatting.
Below is a copy of a previous post of mine and I don't understand the answer
given to me.
How could =AND(ISNUMBER(SEARCH("total",A2)),ISERROR(SEARCH(" grand",A2)))
bold the subtotals in my spreadsheet that I created via DataSubtotal...?
How would the SEARCH and ISNUMBER functions help bold my subtotals in my
spreadsheet?
Can someone help?


P.S. I don't need to bold Grand Totals


-----------------------
Do you want the "Grand Total" formatted also or *just* the subtotals?

http://img527.imageshack.us/img527/9642/formatrx2.jpg

For just the subtotals:

Conditional Formatting
Formula Is:

=AND(ISNUMBER(SEARCH("total",A2)),ISERROR(SEARCH(" grand",A2)))

To include the Grand Total:

=ISNUMBER(SEARCH("total",A2))

Biff
----------------------
"Studebaker" wrote in message
...
Hello,

I have a very big spreadsheet that is sorted by customer name. I have it
subtotaled by using DataSubtotals. I want to bold each of the subtotal
values. In the example below, that would be the number, "6.00".
Ex:

ABC Co. 2.00
ABC Co. 4.00
Subtotal ABC Co. 6.00

I tried using Conditional Formatting to say bold every number with the
formula, "=SUBTOTAL(9,D9:D10)" b/c the #s that Excel subtotals, like the
"6.00" in the ex: above, have a formula in the cell with "=SUBTOTAL(...)".
It's not working.
The spreadsheet is too big to go through manually and bold the subtotals
so
I need some kind of formula to put in the 'Formula is:' box of the
Conditional Formatting dialog box to do this for me.

Can someone help?

Thank you very much,
Studebaker

The Search looks in the cell for that text, and if found returns its
position, if not it errors. So doing an ISNUMBER test against that result
returns a TRUE if it is there, FALSE if not. This is just what CF needs to
apply the formatting or not.

It works.

--
HTH

Bob

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

"Studebaker" wrote in message
...
I'm trying to make bold the subtotals in my spreadsheet I created via
DataSubtotal... using a formula in Conditional Formatting.
Below is a copy of a previous post of mine and I don't understand the
answer
given to me.
How could =AND(ISNUMBER(SEARCH("total",A2)),ISERROR(SEARCH(" grand",A2)))
bold the subtotals in my spreadsheet that I created via DataSubtotal...?
How would the SEARCH and ISNUMBER functions help bold my subtotals in my
spreadsheet?
Can someone help?


P.S. I don't need to bold Grand Totals


-----------------------
Do you want the "Grand Total" formatted also or *just* the subtotals?

http://img527.imageshack.us/img527/9642/formatrx2.jpg

For just the subtotals:

Conditional Formatting
Formula Is:

=AND(ISNUMBER(SEARCH("total",A2)),ISERROR(SEARCH(" grand",A2)))

To include the Grand Total:

=ISNUMBER(SEARCH("total",A2))

Biff
----------------------
"Studebaker" wrote in message
...
Hello,

I have a very big spreadsheet that is sorted by customer name. I have it
subtotaled by using DataSubtotals. I want to bold each of the subtotal
values. In the example below, that would be the number, "6.00".
Ex:

ABC Co. 2.00
ABC Co. 4.00
Subtotal ABC Co. 6.00

I tried using Conditional Formatting to say bold every number with the
formula, "=SUBTOTAL(9,D9:D10)" b/c the #s that Excel subtotals, like the
"6.00" in the ex: above, have a formula in the cell with
"=SUBTOTAL(...)".
It's not working.
The spreadsheet is too big to go through manually and bold the subtotals
so
I need some kind of formula to put in the 'Formula is:' box of the
Conditional Formatting dialog box to do this for me.

Can someone help?

Thank you very much,
Studebaker