conditional formatting 2007

[peymanebrahimi]

Hi,
I have a problem in conditional formatting in excell 2007.
I want to condition format an entire column based on another relative column data.
For example I want to set background of each cell in column A to red according to relative values in column D.
If
$A1 > $D1 then RED
$A2 > $D2 then RED
....
I didn't find a solution in Excel 2007 conditional formatting.
However it may work to relative cell reference in Excel 2003.

Peyman

 

[VoG]

Hello and welcome to MrExcel.

Select all the data in Column A, Conditional Formatting > New Rule > click Use a formula... and enter

=A1>D1

Click the Format button and apply the format.

 

[peymanebrahimi]

Thank u VoG
But it does not work properly
For instance when i check A3 conditional formatting, Manage Rules, Current selection
it shows formula =A2>D2
and for any other cell
and this is not what i am looking for.
i want it to be A3>D3
Does it work on your Excel 2007?
regards

 

[VoG]

Yes, I tested it in Excel 2007 before posting.