On-the-fly Comment Highlighting

  • When a user enters a comment in a cell, and you would like to flag that cell in a different color to make it stand out as a commented cell, here's how.

    I initially wrote this because users were having trouble distinguishing which cells had comments. When a user enters a comment (RightClick > Insert Comment) in a cell, it will highlight the cell in a light shade of green to make it stand out.

    The only thing I didn't include is a way to remove the highlight if a comment is deleted. Although, that could be easily implemented.

    This code should be pasted in the "ThisWorkbook" object in your VBA editor:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!