IF statement --- repost

[lovepeaceofmind]

Hi, ALL:

Not sure why my previous post didn't show up. This is a repost.

Basically, if I shade a cell with color green (cell format\pattern), I
want to return a pure number of 1. Otherwise, return a value of 0. How
to achieve this by using a if statement?

Thanks,

Jorge

 

[PCLIVE]

This was the reply to your previous post.

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.
__------------------

Basically, your if statement will be something like this:

=IF(A1>0,1,0)

But we still need to know how the conditional formatting is set up before an
accurate formula can be written.

Regards,
Paul

 

[JE McGimpsey]

You'll need to use a macro/UDF:

See

http://cpearson.com/excel/colors.htm

 

[JE McGimpsey]

PCLIVE:

No, the OP didn't say that he/she used Conditional Formatting...

 

[PCLIVE]

Sorry JE, My mind read faster than my eyes and I didn't re-read it the
second time.
Thanks for the correction.