• 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.

Conditional Formatting

L

leimst

Member
Good Morning All,

I'm struggling with a Conditional Formatting formula. I have a spreadsheet with a "Manager" column that has a dropdown in it. The problem is that often the users "Cut and Paste" their entries thereby by-passing the restrictions that the dropdown list is trying to impose. Is it possible to use conditional formatting to highlight those "Cut and Paste" entries that do not match anything in the dropdown list? I would like to just keep the users from cutting and pasting altogether but if I lock the cells and the particular sheet, then they cannot make any entries at all.

Thank you in advance for any assistance,

Leimst
 
Yes, You can apply a similar function to CF to replicate the Data Validation Drop Down and have it apply what ever formatting you require

Can you post a sample file for us to examine ?
 
Shrek shouldn't be there and was cut and pasted. I would like conditional formatting to highlight "Shrek" in order to identify the fact that it is not an option in the dropdown list.
 

Attachments

  • Conditional Formatting.xlsx
    10.9 KB · Views: 1
You must log in or register to reply here.
Back
Top