"Formatting: You can create a conditional formatting in A2 that refers to A1 (create the exact same rules for conditional formatting in A1 and A2). I already wrote a little how to yesterday here. Just follow the instructions and make sure you select both cells that should have the conditional formatting.