Using Excel 2010
I have a spreadsheet that contains numerous comments.
I would like to change the appearance of some of them (e.g. - fill colour, remove line, change font, centre align, etc.), in one operation, i.e. - making changes to the selected comments once & not for each comment.
Any tips on how it can be done?
thanks
Hi Craig,
There is no built in way to edit comment formatting to all or even some comments in one operation. If the comments are all the same then you could make your changes to one and then Copy and Paste Special > Comment to the other cells you want to apply the changes to.
The other option is to set all comments to 'show' then apply the formatting you want to one comment > then click on the outer edge of that comment > double click the format painter icon > left click once on the outer edge of the other comments you want to apply your formatting to.
Note: You have to get your click perfectly on the outer edge of the comment box otherwise the format painter won't apply correctly.
Otherwise it's VBA, I'm afraid.
Mynda
Thanks Mynda. I thought as much...
