if you abnormally terminated you will have to run a regular macro
to reenable events so that the event macro will work.
http://www.mvps.org/dmcritchie/excel/event.htm#problems

For the macro:
you can type this into the Intermediate Window (Ctrl+G) of the VBE
first see if you had a problem
Application.EnableEvents
then if it shows False fix it
Application.EnableEvents = True

For your Conditional Formatting: which would be the best solution
-- Select Cell D1 (or any cell on ROW 1)
-- Ctrl+A to select all cells on workbook (see shortx2k.htm#ctrla if you have Excel 2003)
-- Format, Conditional Formatting
Condition 1: =TRIM($D1)="tcr is later" or use =ISNUMBER(SEARCH("tcr is later",TRIM($D1)))
Condition 2: =TRIM($D1)="tcr not set" or use =ISNUMBER(SEARCH("tcr not set",TRIM($D1)))

I put your TRIM around the $D1 so that if you have multiple spaces they will be
reduced. You could effect the same thing and better for constants by running the TRIMALL macro
in http://www.mvps.org/dmcritchie/excel/join.htm#trimall
if the data is your problem, read about checking your data LEN etc. . .
My page on Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Don't really see the need to give the same reply to each person in the thread.
Please use your name when you post to newsgroups.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bettergains" wrote in message ...
Hello David: thanks for your response. Here is the code exactly (preserving
your credist~). This works to the extent that any cell in Col D with "tcr is
later" gets yellow highligted, but not the row, and the second conditions
(highlight in light blue) doesn't get implemented. So apparently is does
loop through the 100+ rows. Not sure why it isn't cycling through the Select
Case statements. (example from event.htm#case)

"Bettergains" wrote in message
...
Hello:
What could possibly be keepping the conditional formatting from working. I
have tried a very simple format: if text in col D = "hello", backfill is
light yellow:

I have used the "format, conditional formatting" dialogue using the
"forumula is" $D2 = "string". It isn't working. Any ideas?

=""""""