anyway to change the color of the comment tag thats in the top right corner?

For all comments? Or individual ones? For individual ones, while editing the comment, click the border and choose line color from the drawing toolbar.

Rgr, I just found a macro to draw over each one, works nicely for me.

Is there a way to format all comments at the same time, or set a default format??

I also have a macro to record comments to another sheet with the corrasponding sheet and cell listed, is there a way to do the reverse, add comments from a table that has the sheet, cell, and data???

never mind, i have a macro for that now.

Thanks