Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i conditional formate a text box
I have some text boxes set to display the contents of a cell. that cell has
conditional formating to change color when a certain value is entered. I also want the text box fill color to change with that value. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i conditional formate a text box
One way to do it is to use Visual Basic. Here is one solution:
http://www.mrexcel.com/forum/showthread.php?t=12097 You can make the Visual Basic have the same conditions, and set the same background colors, as the conditional formating you are using in the linked cell. HTH, Eric "TML" wrote: I have some text boxes set to display the contents of a cell. that cell has conditional formating to change color when a certain value is entered. I also want the text box fill color to change with that value. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i conditional formate a text box
Here is a simple version that toggles the background and foreground colors of
a textbox if the textbox has a certain value in it: Private Sub TextBox1_Change() If Me.TextBox1.Value = "Y" Then Me.TextBox1.ForeColor = RGB(250, 225, 122) ' Font color Me.TextBox1.BackColor = RGB(150, 125, 222) ' Background color Else Me.TextBox1.ForeColor = RGB(0, 0, 0) ' Font color Me.TextBox1.BackColor = RGB(255, 255, 255) ' Background color End If End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i conditional formate a text box
Me.TextBox1.BackColor = Range("A1").Interior.Color
If this post helps click Yes --------------- Jacob Skaria "TML" wrote: I have some text boxes set to display the contents of a cell. that cell has conditional formating to change color when a certain value is entered. I also want the text box fill color to change with that value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formate | Excel Discussion (Misc queries) | |||
conditional formate | Excel Discussion (Misc queries) | |||
HOW TO FORMATE PART OF TEXT FROM TEXT STRING | Excel Discussion (Misc queries) | |||
Convert text number to number formate | Excel Discussion (Misc queries) | |||
Conditional formate:show by color when expiration dates are overdu | Excel Discussion (Misc queries) |