how do i conditional formate a text box

[TML]

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.

 

[EricG]

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

 

[EricG]

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

 

[Jacob Skaria]

Me.TextBox1.BackColor = Range("A1").Interior.Color

If this post helps click Yes