Printing comment indicator in Excel 2007

[scotthunz]

Hello - I need to print an Excel 2007 spreadsheet where the comment
indicators (little red triangles) print. I don't want the comment itself to
print - I know how to do that - but just to indicator to show that the cell
contains a comment.

If it isn't possible to get the red triangles to print, is there a fairly
easy way to use conditional formatting or something similar to shade those
cells that contain comments a different color?

 

[jamescox]

See

'Print comment indicator - MrExcel Message Board'
(http://www.mrexcel.com/forum/showthread.php?t=43827)

for a possible workaround.

In regards to your comment about having a macro color-code the entire
cell if there is a comment, you could write code that checks to see if
each cell in a range has a comment (by checking the cell's .Comment.Text
property - but note that you will have to deal with the fact that the
check will generate an error that you will have to trap if the cell
doesn't have a comment).

Once you have found a cell with a comment, then the code could change
the interior color of the cell...