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?

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

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


--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
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