A
Alan
With Conditional Formating how do you?:
Column A & B contain numbers.
I set cell A1 with the Conditional Format to show red background if A1 is
more than B1.
I then used the Format Painter to set the balance of Col A with the same
formating applied to cell A1. The problem is that when I use the "Format
Painter" (on Col A) each of the cells in Col B references cell B1.
I want each cell in Col B to reference its adjacent Col A cell.
Column A & B contain numbers.
I set cell A1 with the Conditional Format to show red background if A1 is
more than B1.
I then used the Format Painter to set the balance of Col A with the same
formating applied to cell A1. The problem is that when I use the "Format
Painter" (on Col A) each of the cells in Col B references cell B1.
I want each cell in Col B to reference its adjacent Col A cell.