Conditional format formula

[Mel Smith]

Hello folks,

I am using the following formula to try and create some CF: ="minifs(aj4:aj63,aj4:aj63>0)"

I am trying to achieve highlighting the cell or cells that contain the lowest value that is greater than zero. What is wrong with my formula, please?

Mel

 

[Habtest]

Type this in Rule:
=AJ4=MINIFS($AJ$4:$AJ$63,$AJ$4:$AJ$63,">"&0)

 

[Mel Smith]

Perfect!

Many thanks, Habtest.

Mrel

 

[Habtest]

No Prob, thanks for the feedback