Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
How do i set up if function with more than level limits? | Excel Worksheet Functions |