Conditional Formating. Copy across a row

  • Hi

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!