There's nothing built into excel that does this.

But you can use a UDF that looks at cells and returns the color. But that
function won't recalculate if you change color. You won't be able to trust the
output until excel recalculates.

If you want to use a UDF like this, you can visit Chip Pearson's site:
http://www.cpearson.com/Excel/colors.aspx



Henrik wrote:

Is there a way to make a formula that recognizes the cell color like if A2 is
green, then my formula in B2 would recognize this color and return the value
1, then 0 for yellow and -1 for red for example. - a form of reverse
conditional formatting.

If not, how to to this in vba?

Rgds

--

Dave Peterson