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

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.


wrote in message
ps.com...
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