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