Using MIN in Conditional Format for cells with Formulas
 

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?

Using MIN in Conditional Format for cells with Formulas
 

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
--
Brevity is the soul of wit.


"R Fourt" wrote:

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?

Using MIN in Conditional Format for cells with Formulas
 

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

"R Fourt" wrote:

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?