excel_2009
Active Member
- Joined
- Sep 14, 2009
- Messages
- 318
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!!!

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!!!
