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,

T. Thinh


"T.Thinh" skrev i en meddelelse
...
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


--
Best Regards
Leo Heuser

Followup to newsgroup only please.