![]() |
Select Minimum Field
Use conditional formatting say names are in column A1:A100 and numbers in column B1:B100 select cell B1 Under menu Format / Conditonal formatting, select Formula in first box =MIN(B1:B100) then choose yellow background on the patterns ta -- Special- ----------------------------------------------------------------------- Special-K's Profile: http://www.excelforum.com/member.php...nfo&userid=747 View this thread: http://www.excelforum.com/showthread.php?threadid=56327 |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com