Cond Formatting a subtotal row

[Cary]

How does one CF a Subtotal Row? Subtotal Cell?

Thanks

 

[Bob Phillips]

What do you mean? What is the condition in this case, and why is it
different to conditionally formatting any other cell?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Cary]

Simply restated, how do I get Excel to highlight those rows in a
spreadsheet which contain the formula SUBTOTAL?

I have tried Formula Is Subtotal to no avail

 

[Pete_UK]

If they have been generated by means of the Data | Subtotals routine,
then you can group and ungroup rows using the symbols in the panel on
the left.

If instead they have been manually generated by inserting rows at the
appropriate point, then these rows can be selected by means of an
Autofilter on a column which does not have the formulae - selecting
<blanks> as the criteria. Note that the subtotals will show 0 if this
method is used, but if you only want to format the visible rows this
does not matter.

Hope this helps.

Pete

 

[Bob Phillips]

Just test for the value "Total" in the cell in CF, such as

=ISNUMBER(FIND(A1,"Total"))

I have assume that you know how to create CF with formulae conditions.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)