Excel 2007 : Conditional formatting for shortest time

[darkknight4251]

I'm trying to use conditional formatting to color a cell green when the value in the cell is the shortest time from the rest of the selected cells. For example, if F3 is shorter than F10 and F16, color the cell green. I have tried several different ways of adding the formula, but it never colors the cell. Anybody have any ideas on how to code this?

[zbor]

Try this in CF: =F1<=MIN(F2:F$100)

[darkknight4251]

Thanks, but I couldn't get that to work for me unfortunately. I've attached the spreadsheet that I'm using with the values already there. I'm trying to color the least amount of time in column F.
times.xlsx

[Fotis1991]

Hi darkknight4251

Using an unusual way(one helper column), i give you the result that you are looking for.

Pls take a look, to the attachment.

Hope to helps you

[darkknight4251]

I made an error when I posted the spreadsheet though and forgot to take out the extra totals to show what I needed. Attached is the correct totals that I would need to look at. The formula would need to look at specific cells and not use a range. So in the attached example, I'm trying to fill in the cell that has the lowest amount of time between cells F3 F10 and F16. Thanks for all the efforts!

times2.xlsx

[zbor]

Try look here:

[darkknight4251]

Crap, I uploaded the wrong file again. I guess my luck just isn't working this week . Here's the example file that I tried to upload last night. Again, I'm trying to fill in the cell that has the lowest amount of time between cells F3 F10 and F16. I can't use a range for them, because there will be unrelated figures filled in later in column F. That's my main problem as the formulas that you have all given me work with a range of cells, but not specific cells.

[zbor]

If inf other cells in F column is text or numbers greater than 1, then this formula will work.

Based on those new inputs I think you need:

Write this in CF for F3: =$F3=MIN($F$3;$F$10;$F$16)
Select formatting
Then copy cell and paste-spetail -> Formats in other two cells.

[zbor]

If you have much more times and you can't make manuall each cell, then in some other column (for example G) write in F3: =IF(F1="Total time",F2,"")
And you'll get only those times.. Now you can use =$G3=MIN($G$3:$G$10000) to select all cells...


Or =$G3=<MIN($G3:$G$10000) for previous solution.

[Fotis1991]

Hi

So you need for each of three cells, a quiet different formula

Take a look to the attachment and tell us if it's OK.

[darkknight4251]

It works now! Thanks to all of you for your help with this and your patience with my screw ups!