Sorry - found an error in the original post.

Should be: If F4 is not , color the cell (or cells if multiple exist with
the same
value) that have the lowest price in the range J4:Q4.


"jmcclain" wrote:

Using Excel 2003...

Trying to compare cells J4:Q4 to cell F4. F4 will be colored yellow if
F4all cells in the range of J4:Q4 excluding blanks.

If J4 is not , color the cell (or cells if multiple exist with the same
value) that have the lowest price in the range J4:Q4.

Can anyone suggest the proper formula?

Regards,

Jon