Conditional Formatting - continue CD to next row with a different limiting factor

[deck-b]

Hi

I am tying to continue a CD from top row of a table to the next 100 rows. I have tried the format painter but this holds onto the first row as its limiting factor, and i have tried removing all $ signs but is still not working

A1 = 10 B1 = 12 - i want B1 to be red
A2 = 15 B2 = 8 - i want B2 to be green

when i use format painter to the next 100 rows - the limiting factor stays at A1 cell, i want this to change to A1 A2 A3 A4 etc.

Any suggestions?

Thanks

 

[Aryatect]

Hi,

If I understand correctly, you wanted to subtract A1-B2 and if you get positive then RED, if you get negative then GREEN. What should happen in case of a tie?

https://drive.google.com/open?id=1bwnAqx-dUT5ByhK6sNjmXVU7LPjjs0lf
https://drive.google.com/open?id=1iZLspwM_o3mZLQb-Onm76bj6C70WkrnE

 

[deck-b]

Hi, yes you are correct, in case of a tie it should be green