Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple distances versus lowest time for a specific distance
What is the formula for multiple distances versus a specific time, eg in one
colum there is a distance of 50, 100, 200 and the colum beside it there is a time. I am looking for a conditional formatting that gives me a specified colour for the lowest time for a specific distance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple distances versus lowest time for a specific distance
A1:A10 = distance
B1:B10 = time Select the *entire* range B1:B10 starting from cell B1. Cell B1 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell. For Excel 2007: Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =B1=MIN(IF(A$1:A$10=your_number,B$1:B$10)) Click the Format button Select the desired style(s) OK out In Excel versions 2003 and earlier: Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =B1=MIN(IF(A$1:A$10=your_number,B$1:B$10)) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "shell aw" <shell wrote in message ... What is the formula for multiple distances versus a specific time, eg in one colum there is a distance of 50, 100, 200 and the colum beside it there is a time. I am looking for a conditional formatting that gives me a specified colour for the lowest time for a specific distance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Time from Speed and Distance? | Excel Worksheet Functions | |||
How do I get speed given time (hh:mm:ss) and distance in Excel? | Excel Worksheet Functions | |||
Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
time/distance calculation | Excel Worksheet Functions | |||
Time and distance formula | Excel Worksheet Functions |