conditional formatting and comments

  • Thread starter Thread starter puting_uwak
  • Start date Start date
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
 
Jacob Skaria said:
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
Click to expand...


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.
 
puting_uwak said:
can i apply conditional formatting only for cells that have comments?
Click to expand...


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?
 
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
 
Back
Top