LinkBack URL
About LinkBacks
I have a formula to sellect the lowest value in a row of cells =MIN(A1,A2,A3,A4,A5,A6....) but i would like that lowest cell to become highlighted when selected so i can see a glace which number is being used. Any help would be much appriceated. jk
I have a formula to sellect the lowest value in a row of cells =MIN(A1,A2,A3,A4,A5,A6....) but i would like that lowest cell to become highlighted when selected so i can see a glace which number is being used. Any help would be much appriceated. jk
Did you try using Conditional Formatting?
Use conditional formatting
Say your range is A1 to A6. Select the range > Format > Conditional Formatting > Formula and add this formula
Change range as required=AND(A1<>"",A1=MIN($A$1:$A$6))
Also you could change your first formula to
http://www.contextures.com/xlCondFormat01.html=MIN(A1:A6)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks