PDA

View Full Version : Fctns LARGE & SMALL Don't Work in Cond Fmtting Formulas



Cyberdude
12-27-2006, 01:21 PM
I just tried to use the worksheet functions LARGE and SMALL in a conditional formatting formula, and they always result in TRUE. When I use the same formula in a cell on the worksheet, they work correctly.

Has anyone else had a similar result?

Shazam
12-27-2006, 01:50 PM
I just tried to use the worksheet functions LARGE and SMALL in a conditional formatting formula, and they always result in TRUE. When I use the same formula in a cell on the worksheet, they work correctly.

Has anyone else had a similar result?


Hi Cyberdude,

Try...

Assuming your data is in column A. Select cell A2 then type this formula in the conditional format box.

$A2=LARGE($A$2:$A$30,1) and copied down the format.


See if that helps.