Please can anybody help!!!!

How do I copy the font colour of a cell to a textbox.
Say, cell "A1" font colour changed to RED, then the textbox that is linked
to that cell changes as well.
--
Sophie

--
Sophie

This will not work if the cell color is changed using Conditional
Formating,
Place this code in the Worksheet Module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
TextBox1.BackColor = Range("A1").Interior.Color
End Sub

Thanks Curly,
Unfortunately that is what I was looking for. My cells change colour by
using conditional formating.
I take it there isn't a way then?
--
Sophie


"CurlyDave" wrote:

This will not work if the cell color is changed using Conditional
Formating,
Place this code in the Worksheet Module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
TextBox1.BackColor = Range("A1").Interior.Color
End Sub

Probably not, VBA would be needed to color the cells and textBox
conditionally

Thank you Curly. I'll have to dig out a conditional vb code to do this!!!!!
some how!!!
--
Sophie


"CurlyDave" wrote:

Probably not, VBA would be needed to color the cells and textBox
conditionally