conditional formatting if cell contains comments

**jwewing23** · 10-03-2008, 03:19 PM

Is it possible to use conditional formatting on a cell if it contains comments, how would I accomplish this?

**dominicb** · 10-03-2008, 04:42 PM

Good evening jwewing23

Originally Posted by jwewing23

Is it possible to use conditional formatting on a cell if it contains comments, how would I accomplish this?

It is possible using VBA. Conditional formatting can use customfunctions, so we'd need a custom function first to determine whether or not a cell contains a comment :

Please Login or Register  to view this content.

Then from, say, A1 go to Format > Conditional Formatting and select Formula Is and use a formula like this :
=IsComm(A1)=TRUE
and select your format.

HTH

DominicB

**VBA Noob** · 10-03-2008, 05:03 PM

dominicb,

You don't need the true statement for CF

=IsComm(A1)

jwewing23,

Here's a variation on dominicb cool code.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Using

=HasCmt(A1)

VBA Noob

**renjithplr** · 06-24-2010, 05:53 AM

I have comment in the cell, the comments are unique (1. abc) and (2. abc). so i just want to return true if the cell comment says (1. abc) and false if the cell comment says (2. abc). please guide me.