Thread: how do i conditional formate a text box
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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 With QuoteReply With Quote