Hi Excel GurusI would like to set up a conditional formatting where if a certain cell contains >0 then open the grouped rows, if not leave closed. Is this possible?Below is a snap shot of the worksheet grouped rowsThanksPam

Only with VBA I think. I'm not the person to write that though :(

Thanks for the reply Philip, I'm not up to VBA level, so unless I can find an easier fix I'll leave it to manual opening of groups. Thanks P

Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Pam Laidler

Copper Contributor

Aug 17, 2018

Is it possible to filter a lookup column using a specific criteria?

Hi Excel Gurus
I would like to set up a conditional formatting where if a certain cell contains >0 then open the grouped rows, if not leave closed. Is this possible?
Below is a snap shot of the worksheet grouped rows

Thanks

Pam

excel

Formulas and Functions

Pam Laidler
Copper Contributor
Aug 17, 2018
Thanks for the reply Philip, I'm not up to VBA level, so unless I can find an easier fix I'll leave it to manual opening of groups. Thanks P
Philip West
Steel Contributor
Aug 17, 2018
Only with VBA I think.

I'm not the person to write that though :(