Using conditional formatting to compare values

Hi everybody, I googled my 'problem' and I couldn't find anything that really helped so I figured I would post it here. Basically I have a spreadsheet with prices in it.
There are prices in column "A" and column "D" like so:

A D
2,345 6,789
3,760 1,215
4,210 3,456

and so on...values go from cell A1 to A70 or something like that, same goes for the values in the D column (D1 to D70).

What I basically want Excel to do is to take the value in cell A1, compare it to the value D1 and highlight in color whatever value of the two is the lowest. Then repeat for the next one, compare A2 to D2 and highlight the lowest, then compare A3 to D3 and highlight the lowest and so on...

I have Excel 2007 if that's of any help. I think it's something simple (I feel stupid!) that I have to use conditional formatting but after trying things for over an hour I gave up so here's hoping you guys can lend me a hand.

Thanks in advance!

Originally Posted by rwgrietveld

Select Column D
CF function =D1<A1

Select Column A
CF function =A1<D1


Formatting in any font, border you like

That worked like a charm. Thank you so much.

Originally Posted by NBVC

Select A2:A70

and then Go to Home|Conditional formatting

Select New Rule,

Select use a formula to determine which cells to format and enter

=A2=MIN($A2,$D2)

Click Format and choose from Fill tab.

Close

Select Column D2:D70


And repeat with formula

=D2=MIN($A2,$D2)

I will try this too, thank you everybody for your help.