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.
Bookmarks