Hi,
I am trying to apply conditional formatting to Cells D4:D80 that would change colour based on the value in each cell being lees than or greater than the previous cell... i.e. if D4 is £25.00 and C4 is £20.00 then i want D4 to turn Green if its less I need it to turn red. I can manage to do this for one cell but when i try to drag down the formula from D4 to D80 so C8 affects D8 it wont allow me to do this. If someone can help me to solve this i would need to use format painter and apply the same Conditional formatting to Columns 8, 12,16,20 and so on
Im not sure how to attach a copy of the file.. so hopefully this chart helps to visualize what i need.
Thanks in Advance
Susan
[TABLE="width: 581"]
<tbody>[TR]
[TD="colspan: 4"][/TD]
[/TR]
[TR]
[TD="colspan: 4"][TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: center"]Case[/TD]
[TD]Name[/TD]
[TD]Owing [/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]£20.00[/TD]
[TD]£25.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="colspan: 4"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am trying to apply conditional formatting to Cells D4:D80 that would change colour based on the value in each cell being lees than or greater than the previous cell... i.e. if D4 is £25.00 and C4 is £20.00 then i want D4 to turn Green if its less I need it to turn red. I can manage to do this for one cell but when i try to drag down the formula from D4 to D80 so C8 affects D8 it wont allow me to do this. If someone can help me to solve this i would need to use format painter and apply the same Conditional formatting to Columns 8, 12,16,20 and so on
Im not sure how to attach a copy of the file.. so hopefully this chart helps to visualize what i need.
Thanks in Advance
Susan
[TABLE="width: 581"]
<tbody>[TR]
[TD="colspan: 4"][/TD]
[/TR]
[TR]
[TD="colspan: 4"][TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: center"]Case[/TD]
[TD]Name[/TD]
[TD]Owing [/TD]
[TD]Paid[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]£20.00[/TD]
[TD]£25.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="colspan: 4"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]