I would like to have conditional formatting added to a cell what is basically
an if then statement

In cell A2: if A2A3 then (change_red) else (change_green) but when I copy
the formatting to another cell, the cell assignment doesn't change

For example when I copy the formatting of A2 to A14 the logic is
In cell A14: if A2A3 then (change_red) else (change_green)

What I would like to have happen is, when I copy the formatting to A14 then
the conditional formatting would follow if A14A15 then (change_red) else
(change_green)

Thanks,
Rogue