Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the font on a text box dependant on another cell value
hi
I have a text box with a macro assigned to it. I want to be able to change the text colour on the text box dependant on another cell. i.e. if A1=0 then font should be grey (i.e. makes the button look inactive) if A1=1 then font should be blue (i.e. makes the button look active). the macro itself will only run if the A1 condition is set - but I want to make it really simple for my dad to use. thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't change cell value with unusual font. | Excel Worksheet Functions | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Change Currency symbol dependant upon selected cell value | Excel Discussion (Misc queries) | |||
Excel should allow me to change text color & font within tabs. | Excel Discussion (Misc queries) | |||
How can I automatically change the font color of text in cells th. | Excel Discussion (Misc queries) |