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:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
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>