Hello all,

Is there a way......

I would like a comment box to appear in a cell, repeating the contents of another cell, if the cell value is greater than 0.

i.e.

In cell AQ4 I have a sumproduct that counts the amount of times a date appears in a list in another worksheet.

If the total is greater than 0 (dates are found), the cell changes colour - great!

Now I would like to add a comment that displays the names that are associated with the dates found in the sumproduct of cell AQ4.

Hmmm... is this possible?