Is there anything like "format painter" for data validation?
Once I set up data validation for a cell, is it possible to copy those settings to another cell without having to do a cell copy & paste, which will also wipe out destination values and formatting?
When setting conditional formatting, it gets carried along when you do a format paint, but data validation settings are not considered part of formatting.
If VBA is the only way to do this, I can develop that solution on my own but I was hoping there was something built in that I was ignorant of.
Bookmarks