Excel 2007 : Formatting Comments in a workbook

[lbtscsi]

I need to fomat comments, font size, in a template workbook which has 20 spreadsheets. I can do it when I insert one but isn't there a way to do a general formatting for the comments that'll effect the entire workbook when a comment is used?

Thanks for any help in pointing me in the right direction,

[Bob1980]

1. Select all of the worksheets at the same time; left click mouse on on worksheet and choose "Select all Worksheets"; or ctrl+clicking on each worksheet tab at the bottom.

2. On the worksheet showing, click in the upper right corner where the rows and columns meet. There should be an arrow pointing down and to the right. This will select everything that was selected during step one and two.

3. Go to conditional formatting and create your conditional format.

4. To discontinue selecting all worksheets at the same time, select on worksheet without pressing ctrl.

Warning: any changes made to on worksheet when multiple worksheets are selected will cause the same changes to be made in the cell/cell range in all selected worksheets.