Ignoring zeros in macro

[PedroMojica]

having trouble typing code to ignore the zeros in the spreadsheet, just trying to bold the lowest number without it being zero. Here is the code I have right now, cant seem to find the right combination to not count the zeros in each column.

Sub BoldMinimum()
Selection.FormatConditions.Delete
Selection.FormatConditions.Add _
Type:=xlExpression, Formula1:= _
"=" & ActiveCell.Address(0, 0) & _
"=Min(" & Selection.Address & ")"
With Selection.FormatConditions(1).Font
.Bold = True
.Italic = False
End With
End Sub

 

[PedroMojica]

tried that one and its not bolding the lowest number still.


Thank you btw for the help

 

[Desu Nota from Columbus]

This macro works perfectly for me on Excel 2003.

Are the numbers in cells C28:G32 actually numbers or could they be numbers-as-text?

Can you post the data you have in C28:G32?

 

[PedroMojica]

Hey thanks for the help but I found another way of approaching this matter that works fine.