Sorting and highlighting cell values

I have a 18 column 12 row worksheet. I want the lowest value in each column highlighted. However if the column has more than one lowest value I don't want any value highlighted. Is there any way of doing this? For example column one contains the numbers 1-10 lowest highlighted would be 1, now column two as the numbers 1-9 and another 1 I don't want either of these highlighted, hope that helps. Thanks in advance.

Hi & welcome to the board.
You can use conditional formatting for that.
Assuming your data is in A1:R12, select that range & use this formula
=AND(A1=MIN(A$1:A$12),SMALL(A$1:A$12,2)<>A1)

WELL THAT WORKED SORT OF....... like I said and let me clarify I want the lowest number in each COLUMN highlighted, but if in any one column two cells contain the lowest value I don't want either of those in that column highlighted, still keeping the other highlighted in the other columns.

That's exactly what that formula does.
Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	11	11	11	11	17	7	7	2	10	10	7	5	18	20	17	13	4	18
2	10	15	6	17	19	9	6	5	15	11	14	17	20	8	15	16	6	9
3	12	10	7	6	10	7	17	6	14	11	3	15	16	13	9	2	1	4
4	1	9	17	17	17	16	15	16	3	16	20	6	11	12	10	2	16	18
5	7	1	11	20	20	3	6	8	6	8	11	10	14	12	10	20	1	20
6	7	19	6	19	1	8	12	14	2	14	11	18	16	17	16	5	7	5
7	19	19	19	6	5	20	1	9	15	9	5	11	2	14	1	17	16	8
8	17	18	16	1	13	13	12	7	9	10	11	15	2	13	17	1	6	14
9	19	15	19	16	2	8	2	2	8	18	16	19	18	16	10	13	16	12
10	15	10	3	14	1	7	10	8	6	14	9	6	4	2	6	2	13	14
11	3	2	7	7	8	17	6	18	16	2	10	14	7	16	4	8	19	15
12	17	19	13	1	17	19	5	6	8	2	6	19	1	6	4	1	12	9

Sheet: Summary

Thanks for all your help, my dumb self had a value typed in wrong, it works perfectly !!! Thanks I appreciate your help !!!!1

You're welcome & thanks for the feedback.

Well as long as you helped me greatly I have one more question, if you don't mind. I have the formula you gave me working properly in all instances, however is there any way to count these highlighted/formatted cells giving me a result i could use in another formula further down the page? Thank You so much .. you appear to be my lifesaver !!!

~Bob

As this is a totally different question, I would suggest you start a new thread.