• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HELP Needed

A

ashwithonline

Member
Hi All,

In this file i am trying to protect the retail column only but its protecting the whole sheet which i dont want ...the password is ICA.

Also I want to highlight the Product ID of which the difference between Retail and Wholesale Price is more than 20.

regards,
Jagdish
 

Attachments

  • BCA File Set.xlsx
    26.1 KB · Views: 3
With the worksheet unprotected, select the sections you don't want to protect, right click | fromat cells | security tab - deselect LOCKED. Now reprotect, but as you do, scroll down and tick (check) the option to allow autofilters, otherwise your slicer won't work.
 
You must log in or register to reply here.
Back
Top