Microsoft Office Forums Extracting Cell color

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2009, 07:03 AM
bsaucer bsaucer is offline Extracting Cell color Windows XP Extracting Cell color Office 2007
Novice
Extracting Cell color
 
Join Date: Jun 2009
Posts: 1
bsaucer is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 06-19-2009, 06:52 AM
thhui thhui is offline Extracting Cell color Windows 2K Extracting Cell color Office XP
Novice
 
Join Date: Mar 2009
Posts: 6
thhui is on a distinguished road
Default

See the following page of User-Defined Color Function in Excel

http://www.cpearson.com/excel/colors.aspx
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 04:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft