conditional formatting and comments

[puting_uwak]

can i apply conditional formatting only for cells that have comments?

 

[Jacob Skaria]

Press F5>From Goto window select Comments (default)>OK will select all cells
with comments...Then apply conditional formatting.

If this post helps click Yes

 

[puting_uwak]

Press F5>From Goto window select Comments (default)>OK will select all cells
with comments...Then apply conditional formatting.

If this post helps click Yes

thanks for replying jacob! what i was actually looking for is a formula
that i can enter in conditional formatting to automatically format cells that
have comments in them. for example, if insert a comment in a cell, the cell
will automatically be filled with blue. if i remove the comment, the cell's
fill color will be removed.

 

[kiboy^palaboy]

can i apply conditional formatting only for cells that have comments?

i have a column of data and some of them had a comment,can i directly select
the column and apply conditional formatting for that data?

 

[Jacob Skaria]

Here we go...

You will have to use a UDF before trying the conditional formatting. If you
are new to macros set the security level to low/medium in
(Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a module and paste the below code. Save. Get back to
Workbook.

Function HasComment(varRange As Range) As Integer
If Not varRange.Comment Is Nothing Then HasComment = 1
End Function

Now select cell A1. From menu Format>Conditional Formatting>Select 'Formula
Is' and enter the below formula.
=hascomment(A1)=1
and select your color. It is blue right....

Try out and feeback...

If this post helps click Yes

 

[puting_uwak]

Here we go...

thanks so much! your solution works like a charm!