Highlighting the first and second lowest value excluding any zero entries

[BigKeyes13K]

I am attempting to highlight the lowest and second lowest value, separately, in a field of data, ignoring any entries of zero. The lowest value would be highlighted green, the second lowest value would be highlighted yellow so the formulas must be separate for each, and I am looking to highlight only that number. I am rather novice at this and I have been trying to piece together formulas from these forum groups, adding dollar signs however those work, just stabbing blindly until it works. My current attempt to accomplish this is as follows:

This has given me the following result.

The red is from a separate rule affecting the row so that's fine. It has identified the correct number for lowest and second lowest, but it is highlighting every number lower, not just that number and only that number. The green rule was given a higher priority just so it would show up at all. As I type it now occurs to me that I could create a higher priority rule to have no fill for any number that is zero, but I do kind of want to know the correct way to write this.

Thank You.

 

[Peter_SSs]

You need TRUE for that argument. Although you are sorting a row, you are doing so by the relevant column values.
Because you have changed direction, you also need to change the $ signs from the row values to the column values.
It seems that you are now trying for the highest 2 values. If that is the case then there is no need to filter off the blanks/zero values.

See if this does what you want.

23 05 18.xlsm
	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
17	20	2	2	9	1	2	9	3	3	15	2	2	8	3	2	27	0	0
18	0.1			0.11			0.33			0.13			0.38			0
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M18:AD18	Expression	=M18=INDEX(SORT(UNIQUE($M18:$AD18),,-1,TRUE),2)	text	NO
M18:AD18	Expression	=M18=INDEX(SORT(UNIQUE($M18:$AD18),,-1,TRUE),1)	text	NO

 

[BigKeyes13K]

Ok, thank you. And now I understand the dollar signs a little better.

 

[Peter_SSs]

Cheers.