Change Color in cell by lowest dollar value on row

[craigwojo]

I'm making a chart to see which vendor has the lowest price for the same product. I have 4 values (F4, I4, L4 and O4). I would like to have the lowest value of the cell use the "data validation" option and make the cell a light green (or whatever color I choose).
How can I do this?

Thank you and have a Merry CHRISTmas.
craigwojo

 

[etaf]

Using Conditional formattin
for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

F4, I4, L4 and O4


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=F4=MIN($F4, $I4, $L4 , $O4)


FormatÖ [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Not sure I understand the DataValidation part

Book1
	F	G	H	I	J	K	L	M	N	O
3
4	6			5			4			3
5
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F4,I4,L4,O4	Expression	=F4=MIN($F4,$I4,$L4,$O4)	text	NO

 

[craigwojo]

Thank you so much.
If I have many rows to do, would I need to do each row independently or is there a way to make it work on each row I select? Note: all cells that I use will be in the same column.

Thank you and God bless.
Craig

 

[etaf]

No,
it was only because you have non-consecutive range

Book1
	A	B	C
1			Formula example
2		1	1
3		2
4		3
5		4
6		5
7		1
8		2
9		3
10		4
11		5
12		6
13		1
14		2
15		3
16		4
17		5
18		6
19
Sheet1

Cell Formulas
Range	Formula
C2	C2	=MIN(B:B)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B:B	Expression	=B1=MIN(B:B)	text	NO

 

[craigwojo]

Thank you etaf.
I'm a little confused but maybe I didn't explain myself completely.

I'm making a chart to see which vendor has the lowest price for the same product. I have 4 values (F4:F99, I4:I99, L4:L99, and O4:99) IN EACH ROW. Also, I have a total of 99 rows total (and probably would be adding more) I would like to have the lowest value of the cell IN EACH ROW use the "data validation" option and make the cell a on each row light green (or whatever color I choose).
How can I do this?

 

[etaf]

I would like to have the lowest value of the cell IN EACH ROW use the "data validation" option and make the cell a on each row light green (or whatever color I choose).

Data Validation, can you explain how that would work, or do you mean conditional formatting
select the NON Contiguous Range $F$4:$F$15,$I$4:$I$15,$L$4:$L$15,$O$4:$O$15
then using a formula rule
=F4=MIN($F4,$I4,$L4,$O4)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Product					Vendor1			Vendor2			Vendor3			Vendor4
2
3
4	Product1					1			2			3			4
5	Product2					4			5			7			8
6	Product3					2			1			3			7
7	Product4					8			7			3			5
8	Product5					9			7			3			7
9	Product6					10			8			22			7
10	Product7					12			9			2			7
11	Product8					14			10			44			7
12	Product9					16			11			5			7
13	Product10					18			12			77			8
14	Product11					2			13			4			8
15	Product12					2			1			6			8
16
17	I have 4 values (F4:F99, I4:I99, L4:L99, and O4:99) IN EACH ROW. Also, I have a total of 99 rows total (and probably would be adding more) I would like to have the lowest value of the cell IN EACH ROW
18
19
20
21
22
23
24
25
26
27
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F4:F15,I4:I15,L4:L15,O4:O15	Expression	=F4=MIN($F4,$I4,$L4,$O4)	text	NO