Compare two cell values show lowest

[SOLTEC]

I want to compare two numeric cell values in A1 & B1 and show the lowest of the 2 in C1

Any help would be greatly appreciated. Thank you in advance.

 

[BigBeachBananas]

Enter in C1:

=MIN(A1,B1)

 

[SOLTEC]

Thank you so much for that answer. It works great, now how would I add a background color of cell say green or yellow based on the column the value is from, please?

 

[AlanY]

Thank you so much for that answer. It works great, now how would I add a background color of cell say green or yellow based on the column the value is from, please?

you can try conditional formatting like this

Book1
	A	B	C
1	24	73	24
2	73	41	41
3	25	50	25
4	35	90	35
5	36	10	10
Sheet1

Cell Formulas
Range	Formula
C1:C5	C1	=MIN(A1,B1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C5	Expression	=C1=A1	text	NO
C1:C5	Expression	=C1=B1	text	NO