Conditional formatting - highlighting min amount

[stephenclarke111111111]

Hi,

I'm after some help please.

I have 4 columns with amounts and #N/A in them and a column next to in showing the Min. I want to highlight the Min amount from those 4 columns.


Column K to N is where I want to highlight the Min --- column O is the Min


=K2:N2=MIN(IF(ISERROR($K$2:$N$2),0,$K$2:$N$2))

This formula isn't highlighting all the rows ?

 

[becci.gott]

Try this...

Select cell K2 and add your conditional formatting

=K2=MIN(IF(ISERROR($K2:$N2),0,$K2:$N2))

Applies to: =$K$2:$N$2

This should apply the conditional formatting to each cell in that row.

If you want to apply it to multiple rows, change the "Applies to" selection.

At the moment, you have the min set up to specifically only look at row 2, rather than relevant row.

 

[steve the fish]

Try this:

=AND(K1=$O1,$O1<>"")

 

[oldbrewer]

amount1	amount2	amount3	amount4	min
9	4	5	6	4							9	4	5	6
5	6	2	9	2			helper table >>>>>>>>>>>>>>>>>>>	5	6	2	9
6	#N/A	4	#N/A	4							6	1E+08	4	1E+08
-3	-7	-8	-1	-8							-3	-7	-8	-1
6	5		9	5							6	5	1E+08	9
5	4	5	4	4							5	4	5	4
				cond format formula in A2
				=A2=$E2		painted across and down
				E2 is picking up the min of the helper table
				which deals with both #n/a and blank cells
				note thr last row with two 4's
				all the mimimums have been highlighted correctly

<colgroup><col span="12"><col><col><col><col span="3"></colgroup><tbody>
</tbody>