billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Happy New Year all
Today I have been attempting to apply the following formula (Highlight Min Value) to a range of columns (A:F) using VBA any suggestions.
=(A1<>0)*(A1<=SMALL(A$1:A$50,COUNTIF(A$1:A$50,0)+1))
Could use small without looking for values <>0
Thank You
Today I have been attempting to apply the following formula (Highlight Min Value) to a range of columns (A:F) using VBA any suggestions.
=(A1<>0)*(A1<=SMALL(A$1:A$50,COUNTIF(A$1:A$50,0)+1))
Could use small without looking for values <>0
Thank You