Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. See this LINK which discusses how to get information on a cell using GET.CELL function in Excel. Notice that Cells A2, A3 and A4 returns 3, 4, and 5 respectively which equates to the cells background color index. This is technically a Macro, if you use this you need to save as a macro enabled file, unless they changed things. It does not have sufficient numbers for the millions of colors that are available in modern Excel. If you want to color-code your cells, use conditional formatting based on the cell values or based on rules that can be expressed with logical formulas.
Anticipating that I already had the answer, which is that there is no built-in worksheet function that returns the background color of a cell, I decided to review this article, in case I was wrong.
While I agree that, in the purest sense, color is not data, it is meta-data, and it has uses as such.
Regardless, IMO, the ColorIndex property is virtually useless, since there is essentially no connection between color indexes and the colors that can be selected in the standard foreground and background color pickers.

Not the answer you're looking for?Browse other questions tagged excel worksheet-function or ask your own question.
Representing an Excel cell address in a formula using the string values of other Excel cells? Why does Uncle Bob suggest that coding standards shouldn't be written down if you can avoid it? In this case, both cells in row 3 should have a different color after the checking operation. This is the Table I have, I want to compare the column J with the column AA for all the values and change the color of the cells that do not equal each other.
Not the answer you're looking for?Browse other questions tagged excel or ask your own question. What does "Longing rusted seventeen daybreak furnace nine benign homecoming one freight-car" mean? See the screenshot and notice how the different intensities of yellow or purple all have the same number. The logic that leads to conditional formatting can also be used in other places to report on the data, regardless of the color value of the cell.

I was amused to notice a citation to the very same MVP article that I used in the course of my ongoing research into colors in Microsoft Excel.
See Color Combinations: Working with Colors in Microsoft Office and the associated binary workbook, Color_Combinations Workbook. Any work that goes into identifying color, any logic that is based on the current cell color, will need to take into account that the theme of a file can be changed to a completely different color scheme. If I succeed, I plan to put it into an add-in, so that I can use it in any workbook, where it will join a growing legion of other functions that I think Microsoft left out of the product. In any case, using the object model, it is relatively easy to determine the current color of a cell.
Theme colors are set with a combination of accent number and shade number, not with fixed RGB values.

How to find a persons cell number by name generator
Find cell phone number by name only you
Sprint phone number lookup by name

Comments to How to get cell color in excel by formula


11.11.2013 at 12:56:42

Lot of men and women are harassed each and caller makes use of distinct phone.


11.11.2013 at 10:43:15

Additional data such as e mail addresses for the person and are authorizing this firm to initiate.


11.11.2013 at 21:16:52

Asset Investigations & Employment resolve for a true.


11.11.2013 at 17:39:28

This means that there nEMLEC's documents are public records and to order the they say.