compare values
 

I would like to compare 3 nonajacent values, bold the lowest value and then
take the lowest value and multiply it by a selected rate of currency.

select one of the cells and <format<conditional formating formula is
cell1<cell 2 set format to bold
select the other cell set conditional format formula is cell 2<cell 1 and
format bold
in the target cell
=min(cell1,cell2)*rate

"hanover" wrote:

I would like to compare 3 nonajacent values, bold the lowest value and then
take the lowest value and multiply it by a selected rate of currency.

Ididnt notice it was three cells
conditional format formula is and(cell1<cell2,cell1<cell3)
similar for other two cells
and target
=min(Cell1,cell2,cell3)*trate

"hanover" wrote:

I would like to compare 3 nonajacent values, bold the lowest value and then
take the lowest value and multiply it by a selected rate of currency.

Now that I can do that, I want to take the minimum value and multiply it by a
currency amount that is selected by radio buttons. Help
"bj" wrote:

select one of the cells and <format<conditional formating formula is
cell1<cell 2 set format to bold
select the other cell set conditional format formula is cell 2<cell 1 and
format bold
in the target cell
=min(cell1,cell2)*rate

"hanover" wrote:

I would like to compare 3 nonajacent values, bold the lowest value and then
take the lowest value and multiply it by a selected rate of currency.