Restricted Dropdown - Find cells that don't comply

Hello All

I am loving this community, it has helped me develop my sheets... so Thank you. This is my first discussion because I can't seem to find answer anywhere:

I have sheet's with multiple dropdown columns on sheet that have restricted values. All these sheets feed other sheets with formulas so it is important to have consistency on inputting correct info on dropdown columns.

I continue to get 'pop-up' to inform that "there are 2 cells in column with unrestricted values".

How can I find these cells to correct them?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Peter Graham My apologies. For whatever reason I missed your screenshots from yesterday. I hope you were able to get it working. If not, below is a screenshot that explains my solution.

    Using this method, you only need to enter the data in the [Allowed Column] one time. You can then reference the entire [Allowed Column] in the contains formula on each row in the Flag column.

    You could even hide the [Allowed Column] if you wanted to keep the sheet looking cleaner.