Highlight column on minimum condition

[sachin483]

i have 2 column from which i have arrived minimum value of 2 column like that i have around 65000 thousands row from which i want to highlighted the cell column from which minimum condition has arrived and if the value of both the column is similar then the first column should get highlighted

col 1	col2	RESULT
18411768	18411768	18411768
6480131	1701180	1701180
2867699	2170980	2170980
415368	415368	415368
4642704	3682704	3682704
1598838	910032	910032
341711	31644	31644
415368	6480131	415368
2867699	3682704	2867699
415368	410032	410032
4642704	4442704	4442704
1598838	1618838	1598838

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[NiMip]

You don't necessarily need the RESULT column. For the conditional formatting, you should choose "Use a formula to determine this formula is true:" and assuming your col 1 heading is in cell A1, the formula should be =IF(AND(A2=MIN($A2:$B2),$A2<>$B2),TRUE,IF(AND($A2=$B2,COLUMN()=COLUMN($A$2)),TRUE,FALSE))

The range your conditional formatting applies to should be the full range of your data; I've deleted the $ signs in the above formula to allow it to follow down the full range.

 

[sachin483]

thanks for the formula as per the formula if the result is true then it is column 1 and for false its column 2 right