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
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