Minimum highlight
Hi Timothy,
Use conditional formating to highlight it, chose "the formula is" and put:
=B2=$d$1
Assuming that you have the minimmum formula on the D1 cell;
regards from Brazil
Marcelo
"Timothy Langaster" escreveu:
Ive a table with prices:
A B C D
Apples 1.50 1.75 =MIN($B2:$C2)
Bananas 2.20 2.19
I use the formula minimum to find the cheaper price but I need also to
highlight the cheaper price on column B or C. Any idea please?
|