I have cells on multiple worksheets all with the same validation settings.
When i change the validation settings of one such cell, i can select to change all similar cells... but this works only within the active worksheet. If I sleect multiple worksheets, the "Validation..." tool is greyed out.
Is there a way to change the validation settings of similar cells on multiple worksheets simultaneously?
Bookmarks