Gord,

That worked perfectly thank you !!

"Gord Dibben" wrote:

CFFormula is: =$F2$C2 entered for G2

Use the Format Painter to copy down to G11

Or simply pre-select G2:G11 and enter the formula is: as above.


Gord Dibben MS Excel MVP


On Tue, 20 Jan 2009 08:09:01 -0800, brewster56
wrote:

I apologize for delay in responding. The holidays came in between and very
busy time of year at work.

Here is my "logic" thus far ...
A numeric value appears in G2 (in this case) as a result of a formula. The
CF I have for G2 works based on the following:

=$F$2$C$2

So if this evaluates to true - everything is fine. I just can't figure out
how to copy it down to all the other cells. I have tried =F2:F11C2:C11, and
I have tried =$F$2:$F$11$C$2:$C$11