Conditional format of values

  • Thread starter Thread starter AlphaBravo
  • Start date Start date
A

AlphaBravo

I have a list of lap times and need to be able to colour
the cells with the fastest and slowest lap times
respectively.
Is there a way in excel I can format the cells beforehand
so that they update when the times are entered?
Thanks for any info
 
Say the lap times are recorded in a range called MyRange and a cell MyCell
is within MyRange
Then the conditional formatting of MyCell might be set to
for maximum (condition 1)
FormulaIs: =MyCell=MAX(MyRange)
for minimum (condition 2)
FormulaIs: =MyCell=MIN(MyRange)

If the maximum coincides with the minimum it would be treated as maximum in
the above example (condition 1 tested first).
 
One way:

Assume the values aer entered in column A.

Select column A with A1 active. Choose Data/Conditional Formatting...

CF1: Formula Is =A1=MAX(A:A)
Format1: <max format>

CF2: Formula Is =A1=MIN(A:A)
Format2: <min format>
 
Back
Top