I want to change the background color of all of my cells with comments to "Rose" so that it is easier to tell which cells have comments at a glance. In order to do this I need to determine cell referances, which I can't at the moment. I can think of only two ways to do this, neither of which I can do at this time:
1) Determine if a specific cell has a comment assoicated with it. By specific cell I mean the referance style:
OR
2) Determine the address of a cell with comments using the "Comments" feature, i.e. what is the address of:
Can anyboad out there help?
Bookmarks