how do i get answer is 1 from CELL("color",sth) function?

[Guest]

I want to use the CELL function like that way, but even i applied many type
of color to the source cell, the return value still 0 . So who can help me to
format a cell so that the result of CELL("color",sth)=1

Thanks,

 

[Leo Heuser]

T. Thinh

I want to use the CELL function like that way, but even i applied many type
of color to the source cell, the return value still 0 . So who can help me
to
format a cell so that the result of CELL("color",sth)=1

Thanks,

"color" has nothing to do with the color of the cell. To get a return value
of 1, you have to format *negative values* in the cell in color.

E.g. custom format 00;[Color3];0