IF statement

[lovepeaceofmind]

Hi:

I definitely need your help!

Whenever i see a cell color as green (done through cell format
\patterns), I want to return a value 1. Otherwise, return a value of
0. How to achieve this using a IF statement?

Thanks for your help!

Jorge

 

[PCLIVE]

First we need to know what the Conditional Formatting is that determines the
cell to be green. You should be able to use the same formula.