I was so close==forgot the =B2 part! Works perfect--thanks so much

"Luke M" wrote:

Selecting cell B2, format - conditional format.
change first box to: "formula is"
=B2=MIN($B2,$D2,$F2)

Set format to a yellow pattern.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Pam M" wrote:

How can I conditional format for minimum if the cells are non adjacent?


A hidden B C hidden D E hidden F
keyed# formula entered# formula entered# formula

I then want to find the minimum of B, D, and F and highlight it yellow.