How to highlight the selected cell

[jeffreykeefer]

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

[snake10]

Did you try using Conditional Formatting?

[VBA Noob]

Use conditional formatting

Say your range is A1 to A6. Select the range > Format > Conditional Formatting > Formula and add this formula

=AND(A1<>"",A1=MIN($A$1:$A$6))

Change range as required

Also you could change your first formula to

=MIN(A1:A6)

http://www.contextures.com/xlCondFormat01.html

VBA Noob