Conditional formating Problem

Hi,

I have 4 columns i am trying to use conditional formating, to find the largest number, and highlight it. I DO NOT want the largest number per column, i want it for all 4 colums. I get the Formula Error popup and AH56 is highlighted in the formula. Am using Excel 2000
The formula i am using is:

''=LARGE(AB2:AB56,AE2:AE56,AH2:AH56,AK2:AK56,1)

Can anyone change formula to work, or an alternate solution?
Thx

From my understanding of the LARGE function, I would say that your first problem is the way you are selecting a broken range. You'll need to ahve this range named to use in the LARGE function because the function is looking for only 2 arguments, the array and then the nth largest number. After defining your range as a name (MyRange for this example), your conditional formatting formula would look like this.

=AB2=LARGE(MyRange,1)

copy and then PasteSpecial formats to all cells in the range 'MyRange'.

HTH

Originally Posted by richardreye

From my understanding of the LARGE function, I would say that your first problem is the way you are selecting a broken range. You'll need to ahve this range named to use in the LARGE function because the function is looking for only 2 arguments, the array and then the nth largest number. After defining your range as a name (MyRange for this example), your conditional formatting formula would look like this.

=AB2=LARGE(MyRange,1)

copy and then PasteSpecial formats to all cells in the range 'MyRange'.

HTH

Richard,

Thx sooo much. "nameing the range works great. Even if i had remembered to name the range, i would not have put the cell reference at the begining of the formula, which i don't understand, BUT it works

Thx again