If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I use a cell format to figure out a data?
Hello:
I have a spreadsheet that has different color fills do denote something: Blue: Planned Orange: Unplanned Grey: Suspended. Can somebody tell me how I can infer the data based on the fill color? venki |
#2
|
|||
|
|||
How do I use a cell format to figure out a data?
You will have to use VBA to grab the colorindex of the cells.
Do you want to do that? See Chip Pearson's site for UDF's for working with colorindex. http://www.cpearson.com/excel/colors.aspx Gord Dibben MS Excel MVP On Mon, 13 Apr 2009 14:19:01 -0700, vvenk wrote: Hello: I have a spreadsheet that has different color fills do denote something: Blue: Planned Orange: Unplanned Grey: Suspended. Can somebody tell me how I can infer the data based on the fill color? venki |
Thread Tools | |
Display Modes | |
|
|