Solved

# Change the Formatting of All Comments Excell 2010

Posted on 2011-10-19
161 Views
I've got a shared Spreadsheet where people have commented and saved their comments, but when I goto see those comments their background has been filled black. This is the case for all the comments. I can go in and change the Font Color of the Comment so I can See it, but there are a ton of comments and I think it's a setting or formatting issue.

I've attached an example of the comments that I pasted into a new spreadsheet.

I wasn't sure if anyone else has run across this issue as well or knew the solution for it.

Thanks
CommentExample.xlsx
0
Question by:thomas-sherrouse

LVL 12

Accepted Solution

Not sure why it happened but here is a macro that will change the fill color of all comments to white.  That way you don't have to do it by hand:).

Kyle
``````Sub ChangeFillColorOfAllComments()
Dim rngCom As Range, rng As Range
For Each rng In rngCom
rng.Comment.Shape.Fill.ForeColor.SchemeColor = 65
Next rng
End Sub
``````
0

Author Closing Comment

Perfect. Thanks!
0

LVL 12

Expert Comment

You're welcome:)
0

## Featured Post

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …