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

T

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,
 
L

Leo Heuser

T. Thinh


T.Thinh said:
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,
Click to expand...

"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
 
Top