I am using a formula for a conditional format, but when I copy it done to other rows using format painter the formula does not change.

The formula is =AND(A10<"Paid",C10<"",C10<today())

Column A is where a flag of "Paid", "Unpaid" is keyed.
Column C is where a payment date is keyed.

I am trying to highlight dates which have past and are unpaid.