Need help with filter & hide issue

[stateofflux]

Hi,

I have a basic quote template (attached) with 3 lines for each product (product image takes up 3 rows and is set to move with rows)

Id like to be able to filter & hide the products with no quantities but i dont know how to do this as 2 cells below quantity cell are blank.

any help appreciated.

Tom

Excel filter issue pic2.jpg

[noboffinme]

Hi Tom,

I think you would need to use VBA coding to do what you're asking.

[peterrc]

Hi,

Conditional formatting may give you what you want.

CF Formula "=AND($C2:D2=0)" and format font to white

Please see attached.

Regards

peterrc

[stateofflux]

Thanks for the help. really appreciate it.

[noboffinme]

That's very good idea, didn't think of that option.