|
After some research.........
Put the following function in a module of the spreadsheet
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)
-Dave-
|