Identify Conditional Formatting

[danesrood]

Dear All

I know how to locate all the cells that have conditional formatting but I have been asked by a colleague to ask if it is at all possible to put some sort of marker in the cell to identify CF similar to a comment.

I would have thought not, so is it possible to insert a comment with say "CF" in all of the cells that have been selected manually or somehow scanning through the worksheet.

As ever any help would be very gratefully received.

Danesrood

[lynnnow]

Take a look here. it was posted in one of the recent posts on putting comments, http://www.contextures.com/xlcomments03.html may be some help.

Lincoln

[danesrood]

lynnnow

Very interesting. Thank you for the link.

Danesrood

[lynnnow]

I found it interesting too, so I have shared it.