Finding data validation cells

users
#1

Is there a way to find all cells in a spreadsheet which have data validity
applied to them? I'm familiar with Mark Invalid Data but want to find all
cells with data validity configured regardless of whether: there is data in
the cell and, if so, whether it is valid or not. Thanks for your help.

#2

Hi :slight_smile:
Did you manage to find a way of finding which cells have had "data validity"
applied to them?
Regards from
Tom :slight_smile:

LeroyTennison wrote