Cell Comments

[Melody]

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]

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

 

[David McRitchie]

Some macros involving cell comments that might help in writing
you own code can be found in
http://www.mvps.org/dmcritchie/excel/ccomments.htm
and in webpages linked in the Related area near bottom of the page