Excel 2007 : Highlight the lowest whole number in a range

[Martin Chamberlin]

Help.

My first post. Can anyone tell me how to condition a range of cells so the lowest integer only is highlighted in a row?

e.g.

14.00, 13.75, 6.00, 3.35, 1.0, 0.25.

I need to higlight only the lowest whole number 1.0

Any suggestions???

Thanks


Martin

[NBVC]

Assuming data is in A1:F1, select that range and then go to Home|Conditional Formatting|New Rule
Select Use a formula to determine which cells to format and then enter formula:

=A1=MIN(IF(MOD($A$1:$F$1,1)=0,$A$1:$F$1))

Click Format and choose colour from Fill tab.

[Martin Chamberlin]

Assuming data is in A1:F1, select that range and then go to Home|Conditional Formatting|New Rule
Select Use a formula to determine which cells to format and then enter formula:

=A1=MIN(IF(MOD($A$1:$F$1,1)=0,$A$1:$F$1))

Click Format and choose colour from Fill tab.

Thats a great start. The lowest whole number in the following row could be any whole number though 1,2,3,4,5,6,7,8,etc

e.g. 14.00, 8.75, 6.00, 4.35, 2.00, 1.25, 0.75

Highlight 2.00. Any other suggestions, there will be multiple rows.

Thanks


Martin

[NBVC]

Remove the current conditional rule...

Assuming the data is in multiple rows, A1:F10

Then select A1:F10 and re-invoke CF as above with formula:

=A1=MIN(IF(MOD($A1:$F1,1)=0,$A1:$F1))

Then click Format and choose colour.

This will highlight the smallest integer in each row.

[Martin Chamberlin]

You are a genius. Solved.

Many thanks


Martin