Conditional Formatting Help

[itsgrady]

Need to highlight the adjacent cell to the right of the cell that is min in a given row. E4, G4, I4, k4, M4, O4, Q4, S4, U4 are the cells where the minimum value are. F4, H4, J4, L4, N4, P4, R4, T4, V4 (text cells) are the adjacent cells to highlight when the minimum value is found.

Example - if E4 is the minimum in the row. E4 and F4 should be highlighted.

Thanks for the help.

 

[Joe4]

Do the following:

1. Select the range F4:V4
2. Go to Conditional Formatting, click on "New Rule", and select the "Use a formula to determine which cells to format" option.
3. Enter the following formula:

=MIN($E4,$G4,$I4,$K4,$M4,$O4,$Q4,$S4,$U4)=E4

4. Click on the Format button, go to the Fill tab, and choose your desired formatting color.
5. Click OK twice

Here is the proof-of-concept:

 

[Alex Blakenburg]

Building on @Joe4's formula but highlighting both cells maybe:

=MIN($E4,$G4,$I4,$K4,$M4,$O4,$Q4,$S4,$U4)=IF(ISODD(COLUMN()),E4,D4)

Or

=MIN($E4,$G4,$I4,$K4,$M4,$O4,$Q4,$S4,$U4)=IF(ISNUMBER(E4),E4,D4)

 

[Peter_SSs]

Do the columns have headings?
If so, can we see what they are?

 

[itsgrady]

Do the columns have headings?
If so, can we see what they are?

Do the following:

1. Select the range F4:V4
2. Go to Conditional Formatting, click on "New Rule", and select the "Use a formula to determine which cells to format" option.
3. Enter the following formula:

=MIN($E4,$G4,$I4,$K4,$M4,$O4,$Q4,$S4,$U4)=E4

4. Click on the Format button, go to the Fill tab, and choose your desired formatting color.
5. Click OK twice

Here is the proof-of-concept:
View attachment 122799

Thanks for helping. Can it also not look zero values or blank cells?

 

[itsgrady]

Do the columns have headings?
If so, can we see what they are?

I’m

Building on @Joe4's formula but highlighting both cells maybe:

=MIN($E4,$G4,$I4,$K4,$M4,$O4,$Q4,$S4,$U4)=IF(ISODD(COLUMN()),E4,D4)

Or

=MIN($E4,$G4,$I4,$K4,$M4,$O4,$Q4,$S4,$U4)=IF(ISNUMBER(E4),E4,D4)

Thanks for helping. Can it also not look zero values or blank cells?

 

[itsgrady]

Do the columns have headings?
If so, can we see what they are?

Thanks for helping. Can it also not look zero values or blank cells?

 

[Alex Blakenburg]

Try:

=LARGE($E4:$V4,COUNTIFS($E4:$V4,">0"))=IF(ISNUMBER(E4),E4,D4)

With E4 to V4 selected

 

[itsgrady]

Do the columns have headings?
If so, can we see what they are?

 

[Peter_SSs]

Firstly, please don't overload your threads with repeats.
For example, you have quoted post #4 four times and you have said "Can it also not look zero values or blank cells?" three times. Each would only need to be done once.

F4, H4, J4, L4, N4, P4, R4, T4, V4 (text cells)

Example - if E4 is the minimum in the row. E4 and F4 should be highlighted.

Can it also not look zero values or blank cells?

Given all of the above, you could also try this. I have assumed the "$" columns would not contain negative numbers. If they could contain negative numbers and you want those included in the "min" calculation then change the ">" sign in the formula to "<>"
I have also assumed that column D does not contain numerical values. If it does, or could, an adjustment could be made to the formula.

itsgrady.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
3		SO $	SO F	EW $	EW F	HE $	H F	SI $	SI F	AT $	AT F	CW $	CW F	V6 $	V6 F	V7 $	V7 F	V8 $	V8 F
4		22	a		e	3	i		m	0	q	3	u		y	3	c		g
5			b		f		j		n		r		v		z		d		h
6		5	c	5	g	5	k	5	o	5	s	5	w	5	a	5	e	5	i
7		0	d	0	h		l		p	0	t	66	x	0	b	0	f	0	j
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E4:V7	Expression	=SUM(D4:E4)=AGGREGATE(15,6,$E4:$V4/($E4:$V4>0),1)	text	NO