COMPARE TWO PRICES

[Guest]

Sorry I am still on my L's

I want to compare the prices of two columns from two suppliers to see which
is the cheapest to enable us to buy better, and so that our staff can quickly
order the cheapest prices without tooooo much thought.
Thanks

 

[Bernard Liengme]

We need to know how the data is set out on the worksheet.

 

[Joerg]

You could use conditional formatting. Assuming that you want to compare
prices in column A and B, go to A1 and from the menu select
Format => Conditional Formatting. Then define Condition1 as 'Cell Value is'
'less than' '=B1' and change the format to a nice color. Press OK
Select cell B1 and repeat conditional formatting with the condition 'Cell
Value is' 'less than' '=A1'

Now use the format painter (or copy - paste special - formats) and copy the
format of A1 down the column. Do the same with B1.

The lower of two prices will now appear with the chosen background color.

Cheers,

Joerg Mochikun