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.