On Feb 8, 9:04*am, Mark wrote:
My 2 cell conditional format works perfect,

But I can't copy a 4 cel copy and Paste special down the column , I think
because the $ signs are in th conditionals.

I'm not sure why they are there, but I know if I remove the $ sign for the
copy paste special or past, My conditionals Split colors or remain.

Formula in O7 is:
=IF(COUNT(D7:N7)0,SUM(D7:N7),"")

*Conditional formulas in O6,O7

=AND(O$7<"",O$7<=0) Green
=AND(O$7<"",O$7=1) Red

I wanted cells until data appeared.

All works fine, cept.

I can not copy it down some 800 lines thru O871
I have text every 4th line.

IS there a way to copy this down and have he cell numbers change with it, an
keep the integrity of the Formula and the conditionals?

Thanks.

As you mentioned yourself, if you remove the $ sign, the problem will
be solved. That $ signs, keep the row number to be a fixed number upon
copying to other rows. bring the cursor to the dollar sign and press
F4 key, you will see four possible combination and choose the one with
no $ sign.