Data Validation Circle Usage

[ipbr21054]

Morning,
I have 2 columns as explained below.
Column J consists of values like Z159, R235, P004, N/A

Column L consists of values like JHMCN129357842S87, N/A

The columns have a drop down where the only selectable option is N/A

When i use the Data Validation Circle Invalid Data option i see a message telling me that there are more than 255 results etc & cant show them all.

Because of this i dont get to see where my real issues are.
How can i get around this please.
Having the values mentioned above in a drop down will never be possible.

 

[sijpie]

Hi ipbr21054

What are your invalid values? How do you recognise these?
Perhaps a macro can do the selection for you and highlight those cells with a different colour, even if there are a million...