Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fill one cell color with text html/rgb color from another
How do I take a long text list of html, #xxxxxx, or RGB 120,0,25 and fill an
adjacent column with the actual color for each. I know how to do them one at a time. This is a LONG list. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fill one cell color with text html/rgb color from another
check this out, from a very astute source:
http://www.cpearson.com/excel/colors.aspx "thewris" wrote: How do I take a long text list of html, #xxxxxx, or RGB 120,0,25 and fill an adjacent column with the actual color for each. I know how to do them one at a time. This is a LONG list. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fill one cell color with text html/rgb color from another
You can copy and paste the html as TEXT and Excel will convert it
automatically. eg copy this: <table<font color="#eeff00"hello and paste special as text. If this text is in a cell then you can convert it by highlighting in the formula bar and pasting to another cell. With a large HTML table you could either copy and paste from a text editor (eg notepad) or copy and paste using the office clipboard in Excel followed by paste special as text. "thewris" wrote: How do I take a long text list of html, #xxxxxx, or RGB 120,0,25 and fill an adjacent column with the actual color for each. I know how to do them one at a time. This is a LONG list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Shortcut for FILL COLOR and COLOR TEXT | Excel Discussion (Misc queries) |