=CELL("color",a1)

[Guest]

=CELL("color",a1) displays 0 irrespective of the color of CELL a1?

 

[Guest]

What is the format of A1?? CELL does not care about the color appearing in
A1, only that the format calls for a color if the value is negative.

 

[Niek Otten]

CELL() only recognizes explicit coloring, not colors through Conditional Formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| =CELL("color",a1) displays 0 irrespective of the color of CELL a1?

 

[Guest]

Tkx Niek - could you pls give me an e.g.

 

[David Biddulph]

Not even that, according to Excel help. It returns 1 if negative numbers
are formatted as coloured, and 0 otherwise. The basic colouring of the cell
doesn't affect it. Even if you change the formatting of negative numbers in
a cell, it may not pick up the change immediately in the CELL() function; I
sometimes find it needs an F9 to force the calculation (even though the
calculation mode is set to Automatic).

 

[Guest]

Tkx Gary
It format = f2- =cell("color",a1) returns 1 irrespective of the value
It format = g =cell("color",a1) returns 0 irrespective of the value

Is there a way to determine the cell value by color?

Fris

 

[Niek Otten]

Hi David,

Yes, I was totally wrong here

Thanks!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message | Not even that, according to Excel help. It returns 1 if negative numbers
| are formatted as coloured, and 0 otherwise. The basic colouring of the cell
| doesn't affect it. Even if you change the formatting of negative numbers in
| a cell, it may not pick up the change immediately in the CELL() function; I
| sometimes find it needs an F9 to force the calculation (even though the
| calculation mode is set to Automatic).
| --
| David Biddulph
|
| | > CELL() only recognizes explicit coloring, not colors through Conditional
| > Formatting
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | =CELL("color",a1) displays 0 irrespective of the color of CELL a1?
| >
| >
|
|

 

[Niek Otten]

Look here:

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Tkx Gary
| It format = f2- =cell("color",a1) returns 1 irrespective of the value
| It format = g =cell("color",a1) returns 0 irrespective of the value
|
| Is there a way to determine the cell value by color?
|
| Fris
|
| "Gary''s Student" wrote:
|
| > What is the format of A1?? CELL does not care about the color appearing in
| > A1, only that the format calls for a color if the value is negative.
| > --
| > Gary''s Student - gsnu200757
| >
| >
| > "Fris" wrote:
| >
| > > =CELL("color",a1) displays 0 irrespective of the color of CELL a1?