Need Help with Excel Formula

MrPurple · 10-25-2003, 05:06 PM

Hey all,

I want to give cells conditional formating.
What I want is to make it so that if the preceding cell has a comment attached to it, the cell next to it will change its color.

Is this possible?

Thanks alot guys

VHockey86 · 10-26-2003, 06:29 PM

I'm pretty sure you could do it with the excel visual basic editor, but I'm not sure if a simple IF function in excel would do it.

MrPurple · 10-26-2003, 06:33 PM

hmm I was afraid of that.
Well thanks for the help anyway

DrDave1958 · 10-27-2003, 06:52 AM

You can find out here.

http://216.92.17.166/board2/

-Dave-

10-27-2003, 07:15 AM

Epidemic is our resident king of Excel, you should ask him before you give up.

DrDave1958 · 10-27-2003, 11:11 AM

After some research.........

Put the following function in a module of the spreadsheet

Function has_comment(mycell As Object) As Boolean

If mycell.Comment.Visible = False Then
has_comment = False
Else
has_comment = True
End If
End Function

Then set the conditional format formula to

=NOT(ISERROR(has_comment(A1))) (for cell A1)

-Dave-