Hi,

You can use Goto Special cells .
CTRL+G displays dialog
Special...
Check Data validation.

You can then select all cells with data validation or this with the same
data validation as the activecell.

Cheers
Andy

pcor wrote:
If I click on Col B I and select DATA/ Validation I get the message:The
selection contains more than one type of validation. Erase current and
continue?"
My question is: How can I find out what data validation are currently in use.
Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info