Protected Sheet with conditional formatting and comments

T

TommyD

Hi all, I have a protected workbook. I have some columns that users ca
change, and based on the some conditional formatting changes cel
colors. Each column also has a comment in the header cell. When
protect the workbook, the comments cannot be seen, and conditiona
formatting will work onetime (when the spreadhseet is first populate
by me), but when the user changes a value, the formatting doesn'
chane. Any help would be wlecome. Thank you
 

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