Sandra,

You said you are copying it from notepad, is the final result going to be in
excel or not? If it is you can use excel autoformating.

"Sandra" wrote:

I need to format several docs every day. They're programs written in Notepad
and any line that starts off with <! is a comment. My job is to copy the
text from Notepad and change all comment lines to be white text with a black
background. Is there some way for Excel to do this automatically?

I know there are other programs besides Notepad but this is what I'm stuck
with doing so I can't change the process.