Posted to microsoft.public.excel.misc
|
|
Formating cells with comments attached
On Sep 17, 1:41*am, Carter wrote:
On Sep 16, 1:15*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Thanks JB
Much more concise.
Gord
On Wed, 16 Sep 2009 08:50:09 -0700 (PDT), JB
wrote:
Function of Gord Dibben may be short:
Function IsComment(c)
*Application.Volatile
*IsComment = Not c.Comment Is Nothing
End Function
http://cjoint.com/?jqrX1HbfG1
JB
On 16 sep, 11:35, Carter wrote:
On Sep 15, 11:59*pm, JB wrote:
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
JBhttp://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.
|