Conditional Format based on minimum values
Posted by Ryan on July 26, 2001 9:08 AM
Does anyone know a formula I could use to find the minumim values in a data set and a apply a conditional format to them. For example:
A1: 100
A2: 99
A3: 94
A4: 92
A5: 90
I would want to condionally format the lowest 2 values in red (A4 and A5). Any assistance that can be provided would be appreciated!
Posted by Aladin Akyurek on July 26, 2001 9:24 AM
Use "Formula is" option on Conditional Formatting dialog.
=OR(A1=SMALL($A$1:$A$5,1),A1=SMALL($A$1:$A$5,2)
Use Format Painter to copy the formatting to the rest of the cells.
Aladin
Posted by Ryan on July 26, 2001 9:41 AM
Thanks Aladin!! This worked perfectly....
