There's nothing built into excel that would allow this.

Maybe you could use a macro that you could run when you want comments updated???

Melody wrote:

Can I conditional or auto format/fill cell comments? I am doing a large
worksheet that is a seating chart. I want certain info to auto fill into a
"comment" and I didn't know if it could be done??? Any suggestions?

--

Dave Peterson