Need Help with Excel Formula

[MrPurple]

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]

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]

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

[DrDave1958]

You can find out here.

http://216.92.17.166/board2/


-Dave-

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

[DrDave1958]

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-