Using MIN in Conditional Format for cells with Formulas

[Guest]

Okay, let me try to explain this correctly.
I have 3 columns. Column 1 is "lap one time", Column 3 is a "total time",
Column 2 is the difference between the two times ("lap two time"). I have
setup Conditional Formating on Columns 1 & 3 to highlight the lowest time
(=B3 = MIN($B$3:$B$93), etc). This works fine.
However I would also like to format Column 2 (the column with the formula
for "Lap 2 time") to show the smallest time there. I've tried =D3-B3 =
MIN($B$3:$B$93) and =D3-B3 = MIN($D$3-$B$3:$D$93-$B$93) but nothing seems to
work. Can this be done?

 

[Guest]

When you say format column 2 to show the smallest time, I'm assuming you mean
you want Excel to find the smallest value in column 2 and place that value
somewhere else on the spreadsheet.

If your range in column 2 is B1:B1000, then =MIN(B1:B1000) would return your
smallest value.

If you want to highlight the smallest value in column 2, you can apply
conditional formatting to column 2 in which you enter the formula I give
above.

Dave

 

[Guest]

Goto Conditional Formatting
Select "Cell value is" "equal to" and insert this formula
=MIN(C3:C93)
Apply appropriate formatting and then click ok.