Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source text
 

in Excel 2003 use functions or conditional formating, how do you copy colour
from another source (reference) text cell to the current cell. (Being used
to colour code reflecting user entered data and selected colours).

Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source text
 

Ah, that makes more sense than your previous message!. The answer is that
you can't (unless the colour in the other cell is by conditional formatting,
in which case you could use an equivalent condition and formatting).
Otherwise you'll need VBA.

http://www.cpearson.com/excel/colors.htm may help you, & other contributors
may well have other suggestions.
--
David Biddulph

"TJH" wrote in message
...
in Excel 2003 use functions or conditional formating, how do you copy
colour
from another source (reference) text cell to the current cell. (Being
used
to colour code reflecting user entered data and selected colours).

Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source t
 

Thank You, that was helpfull. I now need to apply the colour and the
contecnts of the referenced cell to the current cell, preferably without
creating other reference cells. Only background colour and content matters.

"David Biddulph" wrote:

Ah, that makes more sense than your previous message!. The answer is that
you can't (unless the colour in the other cell is by conditional formatting,
in which case you could use an equivalent condition and formatting).
Otherwise you'll need VBA.

http://www.cpearson.com/excel/colors.htm may help you, & other contributors
may well have other suggestions.
--
David Biddulph

"TJH" wrote in message
...
in Excel 2003 use functions or conditional formating, how do you copy
colour
from another source (reference) text cell to the current cell. (Being
used
to colour code reflecting user entered data and selected colours).