danesrood
05-10-2010, 05:59 AM
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
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