there is no built in support for it.

What causes the cell to change value? What kind of textbox (drawing
toolbar? )

You can probably use an event to react to that or use the calculate event to
update on every calculate.

Given that, what do you need to know?

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
I am using Excel 97. Is it possible with code to conditonally format a
textbox or shape depending on the value of a cell on a seperate worksheet
or
even workbook?

If so, can someone assist me with some code, please?
--
Mark