Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

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

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 11:51 PM.

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