Format conditionnel sur commentai
http://cjoint.com/?jqg643N3cc
=comment(A2)="XX"
Function Comment(c)
Application.Volatile
If c.Comment Is Nothing Then
Comment = ""
Else
Comment = Replace(c.Comment.Text, Chr(10), "")
End If
End Function
JB
http://boisgontierjacques.free.fr
On 16 sep, 05:43, Carter wrote:
Hi,
I would like to learn if there is way of using a formula to apply
conditional formatting only to cells that have comments attached to
them. *I have searched for an answer, but haven't found one yet.
Thanks.