View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Visor Visor is offline
external usenet poster
 
Posts: 1
Default Select Minimum Field


Hey guys,

Im having a problem with excel, made obvious by posting here ;)

Anyway I've got a list of names of items, and next to them I have th
prices in plain decimal numbers.

What I'm trying to achieve is to get the cheapest (lowest) result to b
highlighted by say yellow. So change the background to yellow.

I've had a look about on the website and google and can't seem to fin
what im looking for. I have some basic VBA knowledge but can't seem t
put the logic together for it. (assuming this is a VBA task)

If any of you could point me in the right direction. That would b
great :)

Thanks

--
Viso
-----------------------------------------------------------------------
Visor's Profile: http://www.excelforum.com/member.php...fo&userid=3658
View this thread: http://www.excelforum.com/showthread.php?threadid=56327