Any ideas? Thanks!
T thechilipino Mar 21, 2006 #2 hi h2000: one possibility would to use conditional formatting -> 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1)) hth. cheers. thechilipino.
hi h2000: one possibility would to use conditional formatting -> 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1)) hth. cheers. thechilipino.
H Hubitron2000 Mar 21, 2006 #3 Worked great, thanks! thechilipino said: hi h2000: one possibility would to use conditional formatting -> 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1)) hth. cheers. thechilipino. Click to expand...
Worked great, thanks! thechilipino said: hi h2000: one possibility would to use conditional formatting -> 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1)) hth. cheers. thechilipino. Click to expand...
B Biff Mar 21, 2006 #4 =OR(A1=LARGE(range,{1,2,3})) Biff thechilipino said: hi h2000: one possibility would to use conditional formatting -> 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1)) hth. cheers. thechilipino. Click to expand...
=OR(A1=LARGE(range,{1,2,3})) Biff thechilipino said: hi h2000: one possibility would to use conditional formatting -> 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1)) hth. cheers. thechilipino. Click to expand...
