That should work.

--
Regards,
Tom Ogilvy

"Hercules" wrote in message
om...
Thanks for the responses. I was afraid you were going to say that ...
worksheet_calculate is my only option for being alerted to the changes
and conditional formatting as is won't solve my problem. I don't
think I'll use the calculate event since I have about 5 columns that
need to display alerts and the spreadsheet may have up to 500 entries.
For a real time application, it maybe too big of a performance hit to
loop through and call my formatting function for 2500 entries on every
calculate.

This morning I actually had another idea that might accomplish what I
need. Since my alert cells have 3 fonts and 3 different colors, I'm
thinking of breaking them down into 3 different adjacent columns such
that each column only uses one font and color. White cell borders
should provide the appearance of one cell when in fact it is three. I
haven't tried this yet but I don't even think I'll need to use
conditional formatting. I should be able to just initially set the
colors/fonts of each column and then use formulas to display the
appropriate number of characters.