Conditional formatting with formula or some other method

[Zenzalana]

Hi!

I'm looking for a way to compare the values in each column to identify the lowest number per row. I was using conditional formatting with a formula when I originally only had two columns =($A2<$B2) in column A and =($B2<$A2) in column B. Now that I have more values to compare, it isn't working. I'm not too knowledgeable with excel so I'm stuck!

In the sample table below, the row one value I'd like to highlight automatically is '40', row two: '14', row three: '15', etc. The actual data set I'm working with has nearly 20,000 lines.

<tbody>
</tbody>

A	B	C	D	E	F
40	50	60	70	80	90
34	41	14	29	35	46
30	38	46	15	36	28
50	38	14	31	40	49
31	41	15	47	1	21
9	26	5	16	33	17

<tbody>
</tbody>

Any help would be much appreciated

 

[Jonmo1]

Welcome to the board.

Try

=A2=MIN($A2:$F2)

 

[Zenzalana]

Thanks for the welcome and the response!

I applied that and it is not returning the expected results...Here's what it is returning. Am I doing something wrong?

A	B	C	D	E	F
40	50	60	70	80	90
34	41	14	29	35	46
30	38	46	15	36	28
50	38	14	31	40	49
31	41	15	47	1	21
9	26	5	16	33	17

<colgroup><col span="6"></colgroup><tbody>
</tbody>

 

[Jonmo1]

It's all about the 'How' you enter the formula..

You might be best off starting from scratch.
Remove the existing conditional format
Select the entire range you want to apply the format to (from top/left to bottom/right)
Make note of the Top Left cell of the range you selected (probably A2)
Then write the conditional format relative to that cell (as it should appear in that top/left cell)

=A2=MIN($A2:$F2)

 

[Zenzalana]

PERFECTION! Thank you so much.

 

[Jonmo1]

Glad to help, thanks for the feedback.