If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|