How can I get a cell's color with a formula, not with visual?

[Potosi]

I'm trying to detect cells with color, but I don´t want to use VBA code. I
don´t know if is possible using formulas.

 

[Gary''s Student]

You should checkout:

http://www.cpearson.com/excel/colors.htm

even though it relies on VBA, its really not all that painful.

 

[Gord Dibben]

Without VBA you will have to visually look for cells with color unless they were
colored using Condtional Formatting.

In the latter case you can search or filter on the CF value that colored the
cells.

As an alternative, you could use Edit>Find>Options>Format>Choose format from
cell.


Gord Dibben MS Excel MVP