Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting of a text box ? - update (from pg.9)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
conditional formatting with text | Excel Discussion (Misc queries) | |||
conditional formatting text | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Conditional Formatting of Text... | Excel Discussion (Misc queries) |