VBA with conditional formatting help!

[trexlim]

Greetings,

I have a spreadsheet full of price values from Column A to Column xxx.

Column A is my lowest selling prices. (Column A, every row different price)

how to references every column every row from column B onward and "lookup" column A and if the price for that specific cell falls below the same row cell in Column A, it will be highlighted.

Perhaps only VBA can solve this?

thanks in advance!

example:

A (fixed) 34.40	B 34.50	C 34.90	D 33.50	E 34.00
43.50	42.50	43.00	41.30	45.90
60.50	61.10	84.60	81.30	82.40
79.10	74.50	99.70	95.70	97.10
76.30	72.20	101.70	97.60	99.00
91.30	85.60	116.70	112.00	113.60
92.10	83.40	117.60	112.90	84.50
106.90	96.80	132.70	127.40	129.20

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Tim_Excel_]

Seems easily doable with conditional formatting using a formula:
Conditional Formatting > New Rule > Use a formula to determine which cells to format >
1. use the formula =B1<$A1
2. set the formatting
3. apply to col B:E