Function that gives Group level?
 

I'm using the grouping that displays +/- on the left, and I have different
formatting for each level. The automatic styles don't do what I want, so I'd
like to be able to determine what level a row is at and use that in
conditional formatting.

Is there a function that will show what group level a row is?

Jim

Oh good one! And while anyone is at it, how can I
expand / collapse a group from within a protected sheet.
And I don't want to unprotect it to do it either ...

Regards,
Robert
-----Original Message-----
I'm using the grouping that displays +/- on the left,
and I have different
formatting for each level. The automatic styles don't
do what I want, so I'd
like to be able to determine what level a row is at and
use that in
conditional formatting.

Is there a function that will show what group level a
row is?

Jim
.

Ack, you hijacked the thread! Now people are less likely to answer.
Get your own thread, and I mean that in the very best way.

Jim


"Bony Pony" wrote:

Oh good one! And while anyone is at it, how can I
expand / collapse a group from within a protected sheet.
And I don't want to unprotect it to do it either ...

Regards,
Robert