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.