Highlight lowest dollar

[JLR4]

I have a worksheet that updates the current gas prices from my local area. I would like to highlight the cell or cells with the lowest gas price. The first number comes in at J3 and goes down to J33. Some of the cells that update are blank and some have this --- in the cell. How can I highlight the lowest price and ignor blanks and ---.

jim

 

[T. Valko]

I have a worksheet that updates the current gas prices from my local area. I would like to highlight the cell or cells with the lowest gas price. The first number comes in at J3 and goes down to J33. Some of the cells that update are blank and some have this --- in the cell. How can I highlight the lowest price and ignor blanks and ---.

jim

What version of Excel are you using?

 

[barry houdini]

Hello jim, welcome to MrExcel

Select the range J3:J33, starting at J3 and then apply this formula in conditional formatting

=(J3=MIN(J$3:J$33))*(J3<>"")

 

[JLR4]

barry, it worked like a charm!
now I'll take that and try to apply it to the name of the gas station as well.

thank you

jim