Hi all,

I'm new to this forum.

I'd have a question for all you excel / vba experts.

I want to have the cells format background colour changed to RED when I insert a Comment on the cell.

So, if there is no comment, just default to GREEN. When there is a comment, default to RED.

Can this be done with VBA??

I got as far as this;

Function HasComment(Cell As Range) As Boolean
Dim x As Comment
Set x = Cell.Comment
If x Is Nothing Then
HasComment = False
Else
HasComment = True
End If
End Function

But it does not Auto-Refresh the function when i refer the cell to a function.






thanks.