Hope someone can help.
I have a conditional format where A3 will turn green if below the value in A2 and Red if greater than the value in A2.
What do I need to do so I can click and drag or copy the conditional formatting quickly so that B3 will be related to B2, C3 to C2 etc
In the manage rules I have used $A$2 and A$2 and I still can't copy it across. I have also tried Format painter with no success.