You have replies in your other thread. Don't keep starting new ones.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fris" wrote in message
...
if A1 format = F2- =cell(color,a1) displays 1
if A1 format = G =cell(color,a1) displays 0

=cell(color,a1) therfore does not refer to the cell color but rather to
the
format

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