Sorry, no. A comment is just a comment.

It could be done with VBA and the Worksheet_Change() event, at the expense
of a lot of time consumed rewriting your comments in that column every time
something else changed.

"Manju" wrote:

Is it possible to write a formula in comment
What I want is to display a 'value' (say percentage) in comment when I
move the mouse over that particular cell.
If A1 is having value 10 and A2 has a value of 200, when I move the
cursor on cell A1, the comment should display 5.00%.(I know I can add
another column A3 and write a formula over there A1/A2 * 100 but I need
to show it in the comments).
Regards