Conditional Formatting - Hiding Cells & Autofilter

P

Paul

Hi,
I've got a spreadsheet that is protected. It displays the
results of calculations. Lots of the rows have zero value
and I use autofilter to hide the zero rows. When the sheet
is protected the autofilter does not work. Is there any
way to protect the formulae and keep the autofilter
working?

My other idea was to see if I could hide the zero rows
using conditional formatting? Does anyone have any ideas
on this?

Thanks for looking.

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top