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

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.

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

You should checkout:

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

even though it relies on VBA, its really not all that painful.
--
Gary's Student
gsnu200705


"Potosi" wrote:

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.

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

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 EditFindOptionsFormatChoose format from
cell.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 14:07:00 -0800, Potosi
wrote:

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.