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

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(A10,1,0)

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

Regards,
Paul

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

You'll need to use a macro/UDF:

See

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

In article .com,
" wrote:

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:

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

In article ,
"PCLIVE" wrote:

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(A10,1,0)

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

Regards,
Paul

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

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


"JE McGimpsey" wrote in message
...
PCLIVE:

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

In article ,
"PCLIVE" wrote:

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(A10,1,0)

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

Regards,
Paul

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