Seeing which cells have Data Validation rules

[marketshare]

Does anyone know of a way of showing which cells in a worksheet have Data Validation rules applied? Thanks.

[Sadath31]

Select entire range
Edit>Goto Special Button
then Data Validation option button > OK
this will select data validation cells only

[marketshare]

Thanks Sadath31. I cannot find the function to which you refer. I have hunted around but cannot find anything that looks like an 'Edit-Goto Special button'. I am using Excel 2010.
I would appreciate further clarification.

[Sadath31]

Try the short cut to get 'GO TO' dialogbox
Ctl + G

[pike]

Hi marketshare,
In the "home" ribbon > "find Select"> "Goto"
click "special" button and click "Data Validation"

[marketshare]

Got it. Thanks