Conditional Formatting
Posted by Rahmaul coss on February 21, 2001 2:56 PM
I have a column of numbers. I would like the highest number highlighed in red and the 2nd highest number in blue.How can I format this so that when the numbers change the highlighed numbers change if need be.
Posted by Aladin Akyurek on February 21, 2001 3:23 PM
Say we have 3 numbers in A1:A3.
Select A1, activate option Format,Conditional Formatting. Enter the first condtion as "Formula is":
=A1=LARGE($A$1:$A$3,1)
Set Format for Font = Red
Add second condition as again "Formula is":
=A1=LARGE($A$1:$A$3,1)
Set Format for Font = Blue.
Close Conditional Formatting. Click on the Format Painter icon. Apply the formatting to the rest of the cells.
Aladin
Posted by Ian on February 21, 2001 3:34 PM
What a cool function. I think you may have typo'd in the second formula =A1=LARGE($A$1:$A$3,2)?
Posted by Aladin Akyurek on February 21, 2001 3:38 PM
: I have a column of numbers. I would like the highest number highlighed in red and the 2nd highest number in blue.How can I format this so that when the numbers change the highlighed numbers change if need be. =A1=LARGE($A$1:$A$3,1) Set Format for Font = Red Add second condition as again "Formula is": =A1=LARGE($A$1:$A$3,1) Set Format for Font = Blue.
Yep. I have pasted the same formula twice. Thanks for the catch.
Posted by Rahmaul on February 22, 2001 5:58 AM
:
