ExcelBanter - How do I use a cell format to figure out a data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I use a cell format to figure out a data? (https://www.excelbanter.com/excel-worksheet-functions/227554-how-do-i-use-cell-format-figure-out-data.html)

vvenk

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

Gord Dibben

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

All times are GMT +1. The time now is 06:10 AM.