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