anthony20069
12-14-2010, 09:40 AM
Hi all,
Is there a way with VBA to use conditional formatting depending if there is a comment in a cell or not?
i tired with the following:
Function has_comment(mycell As Object) As Boolean
If mycell.Comment.Visible = False Then
has_comment = False
Else
has_comment = True
End If
End Function
Then set the conditional format formula to
=NOT(ISERROR(has_comment(A1))) for cell A1, but that didnot work - also need to to cover the range A1:ZZ1000
anyone got any ideas?
cheers
Is there a way with VBA to use conditional formatting depending if there is a comment in a cell or not?
i tired with the following:
Function has_comment(mycell As Object) As Boolean
If mycell.Comment.Visible = False Then
has_comment = False
Else
has_comment = True
End If
End Function
Then set the conditional format formula to
=NOT(ISERROR(has_comment(A1))) for cell A1, but that didnot work - also need to to cover the range A1:ZZ1000
anyone got any ideas?
cheers