copy and pasting conditionally formatted cells

[twallis]

Hello

My problem: I am creating a spreadsheet which has a table for every day of the year, where one column is formatted to turn red or green should the total of those cells be greater or less than a certain number. However when I copy these tables the formatted column/cells still react to the original column.

I thought I could copy and drag/paste the formatted cells much like a SUM where a sum adapts to it's new location.


Can anybody help me? Do you need more information?

Many Thanks

 

[crimson_b1ade]

if you haven't figured it out by now...then...take the dollar $ signs out of the conditional formatting formula.

 

[twallis]

Hi Crimson b1ade,

That did indeed solve it.

Thanks for replying.