No need to apologize.
Perfect solution. I never even knew about the camera.

Thanks again,

Steve

"ShaneDevenshire" wrote:

Hi Steve,

Sorry to take so long but it was a very busy week.

Replace the drawing text box with a Camera tool picture of the cell.

To add the Camera tool to the toolbar choose View, Toolbars, Customize,
Commands tab, Tools catergory and near the bottom of the list on the right
side.

Select the cell you want to put into the textbox and click the Camera tool,
move the the sheet you want the textbox on and click a cell. Then move it
around as necessary.
--
Cheers,
Shane Devenshire


"Steve" wrote:

I used the drawing texbox.
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