I love this - thanks guys

"CLR" wrote in message
...
And if you want a toggle to turn the whole field off and on, use this
formula in the Conditional Formatting window.........
=AND(LEFT($A1,2)-"<!",$M$1=1)

Then, as long as there is a 1 in M1, the formatting will be as bj
describes,
otherwise it will be toggled off.

Vaya con Dios,
Chuck, CABGx3



"bj" wrote in message
...
You can use condtional formatting
Highlight the excell cells with the information from the notepad
<format<conditinal formating

Set condition one
<formula is =left($a1,2)="<!"
set format for white font color and black pattern

Note it is sometimes necewssary to edit the conditional formats. I have
had
then change from relative to absolute references or visa versa when I
first
hit enter. Also they have a trendency to add odd Quote marks where I
don't
want quote marks.





"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.