#1
|
|||
|
|||
Extracting Cell color
I have been given an Excel spreadsheet (.xls format), and I need to import the table into a SQL (2000) database, which I've done with other spreadsheets in the past. The only problem with this spreadsheet is that one column is color coded with information that I need to extract. Obviously the spreadsheet was made for human eyes.
Each cell may have any one of four background colors which I need to electronically distinguish. I don't even know the "name" or value of each of the colors. They just "appear" red, dark blue, dark green, or light gray. I need to interpret the color into two bits of information (which I could call "C", "S", "both", or "neither"). This table has well over 2000 rows. |
#2
|
|||
|
|||
See the following page of User-Defined Color Function in Excel
http://www.cpearson.com/excel/colors.aspx |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
extracting files from oracle10g into excel | janejuzz | Excel | 0 | 05-18-2009 12:54 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
User seeing other user's color categories | MTFysherman | Outlook | 0 | 11-13-2008 04:36 PM |
need help with font color | samsongee | Word | 0 | 09-07-2006 10:18 PM |
color issues when making a pdf | matt | Publisher | 0 | 03-10-2006 08:16 AM |