Check if value is in validation list

[tiredofit]

Is there a quick way to see to a particular value is in a validation list?

The cell in question contains data validation but ShowError is set to false, to allow users to input whatever figure they desire.

I want to check if they value currently contained in the cell is within the Validation list.

Thanks

 

[jasonb75]

Perhaps use conditional formatting using a MATCH formula as the condition?

=MATCH(entered_item,validation_list,FALSE)

 

[tiredofit]

Perhaps use conditional formatting using a MATCH formula as the condition?

=MATCH(entered_item,validation_list,FALSE)

Thanks