Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source Text | Excel Worksheet Functions | |||
Copy text hyperlinks and paste them as source addresses? | Excel Discussion (Misc queries) | |||
I cant get Excel OFFSET Fnct to return multiple references. | Charts and Charting in Excel | |||
I want to link, not just copy,Word source text to a text box in Ex | Excel Worksheet Functions | |||
Change source text in Excel from all caps to upper and lower case. | Excel Discussion (Misc queries) |