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
|
Similar Threads
