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.

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.

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

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.