Highlight cells that contain data validation

[excel_2009]

Hi Excel gurus!

I was just wondering if there's a way of highlighting cells that contain data validation? I have a spreadsheet that has random data validations across each row, I was wondering if it's at all possible to highlight these cells (that contain a data validation drop down) in yellow or similar?

I've looked online but can't find a way via VBA unfortunately!

Many thanks!!!

 

[Fennek]

Hello

vba specialcells offer

v = cell.SpecialCells(xlCellTypeSameValidation).Count

 Set r = Cells.SpecialCells(xlCellTypeAllValidation)

regards

 

[Fluff]

Or without code
Ctrl G > Special > Data Validation > OK