Conditional Format II

[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.

 

[bobocat]

in Cell A1, condition 1
Formula Is: =$B$1<$A$1, change to red background
then you can copy this format to other cell by format painter

Bobocat from Hong Kong

 

[Alan]

That does not work. Every cell is still referened to B1.

 

[Biff]

Hi!

Try this:

Assume the range in question is A1:A10

Select that entire range starting with cell A1.

Conditional Formatting
Formula is: =AND(COUNT(A1:B1)=2,A1>B1)
Click the Format button
Set the fill pattern to RED
OK out

The cell references will automatically adjust.

I've never used the format painter!

Biff