Hello,
I have 2 sheets in an excel file. One that contains data, and one that contains text boxes. I'm applying conditional formatting in the data sheet (it's numbers, gradient colors)
Does anybody know any code that I could use so that the text box colors it's self automatically (either to press a button etc) with the same color that appears in the cell that is linked to?
This is MS Office 2007 I'm talking about
Thank you
Bookmarks