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