Conditional Format - Copying Formats
 

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.

Conditional Format - Copying Formats
 

Haven't got 2007 but highlight both columns and set CF:


FormulaIs: =$A1<$B1


HTH

"Frank" wrote:

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.

Conditional Format - Copying Formats
 

No, that doesn't work.

"Toppers" wrote:

Haven't got 2007 but highlight both columns and set CF:


FormulaIs: =$A1<$B1


HTH

"Frank" wrote:

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.

Conditional Format - Copying Formats
 

Actually, maybe it did. I crashed Excel, but after recovery, I think it may
have worked. Thanks

"Toppers" wrote:

Haven't got 2007 but highlight both columns and set CF:


FormulaIs: =$A1<$B1


HTH

"Frank" wrote:

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.

Conditional Format - Copying Formats
 

Works in 2003 i.e higlights both A & B if they are different : asI say I
haven't 2007 but I am surprised that such a basic CF does not work.

No copying down required.

"Frank" wrote:

No, that doesn't work.

"Toppers" wrote:

Haven't got 2007 but highlight both columns and set CF:


FormulaIs: =$A1<$B1


HTH

"Frank" wrote:

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.

Conditional Format - Copying Formats
 

in cell A1 enter cf then in cell A2 copy down then special paste choose
formats.

"Frank" wrote:

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.