copying conditon formats with $
Mark,
I amended your file and sent it back to you - did you receive it, and
did it do what you wanted?
Pete
On Feb 8, 7:55*pm, Mark wrote:
I certainly can remove the $ in the ways you describe. But, then the cells
remain at the last color they were at if a date in O5 is removed.
That makes for a lot of color.
I will try what Alojz oferred, barring learning how to do the test!
Mark
Thanks David.
"Khoshravan" wrote:
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.
--
R. Khoshravan
Please click "Yes" if it is helpful.
"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.- Hide quoted text -
- Show quoted text -
|