Quicker way to enter custom forumae

Hello, I am playing around with formulas as suggested in a previous thread.

In the below image, I am able to highlight the cheapest price using a formula such as this: =MIN(IF($L$5:$Q$5<>0,$L$5:$Q$5))=L5

So far, I am having to type in this formula for each of the first 3 rows. Is there a way that this formula can be auto repeated as I have 100's of products that I would like to do this for.

2e6kiiGtzun9.png

Remove the second $ sign in each range reference so that $L$5 becomes $L5 and so on (four references to change), then drag down to fill the formula down.

Col L in your example is hidden in your picture.

If you select M3:O21 with M3 active, use as a CF formula

=M3=MIN(IF($M3:$O3<>0, $M3:$O3))

	M	N	O
3	$ 8.18	$ 8.53	$ 5.50
4	$ 8.32	$ -	$ 7.48
5	$ -	$ -	$ -
6	$ 5.08	$ 6.65	$ 6.92
7	$ 9.58	$ 6.07	$ 7.72
8	$ 8.37	$ -	$ 5.54
9	$ 7.28	$ 5.69	$ 7.78
10	$ 7.31	$ 7.42	$ -
11	$ 8.92	$ 7.92	$ 7.70
12	$ -	$ -	$ 5.28
13	$ 8.25	$ -	$ -
14	$ 8.15	$ 6.91	$ -
15	$ 8.41	$ -	$ -
16	$ 8.53	$ 9.70	$ 6.29
17	$ 9.31	$ 5.58	$ 6.59
18	$ -	$ -	$ 7.55
19	$ -	$ 8.21	$ 9.08
20	$ 6.52	$ 9.28	$ 6.57
21	$ 8.66	$ 9.28	$ 7.42