I used the drawing textbox.
It refers to another cell on another sheet via the formula bar = 'sheet
1'!D$17, which is conditional formatted to be red if < another cell value,
and green if = that same cell value.

"ShaneDevenshire" wrote:

Hi,

First of all there are at least three different kinds of Text boxes - which
one do you mean? The one on the Drawing toolbar, the Forms toolbar, or the
Control Toolbox?

Second, what kind of format is the Conditional Formatting applying? Font
Style is passed to the Drawing toolbar textbox for example.

Anything else will probably require VBA if it can be done.
--
Cheers,
Shane Devenshire


"Steve" wrote:

I have a cell conditional formatted as red or green depending on the value.
I have a text box on another sheet referring to that cell.
Can the text box contain the same conditional formatting ?
And if so, how do I do it ?

Thanks,

Steve