Subtotals & Conditional Formatting Part 2

S

Studebaker

I'm trying to make bold the subtotals in my spreadsheet I created via
Data>Subtotal... 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 Data>Subtotal...?
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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top