| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting when cell value is top 3 of column . . .
Any ideas?
Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting when cell value is top 3 of column . . .
hi h2000:
one possibility would to use conditional formatting - 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(r ange,1)) hth. cheers. thechilipino. "Hubitron2000" wrote: Any ideas? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting when cell value is top 3 of column . .
Worked great, thanks!
"thechilipino" wrote: hi h2000: one possibility would to use conditional formatting - 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(r ange,1)) hth. cheers. thechilipino. "Hubitron2000" wrote: Any ideas? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting when cell value is top 3 of column . . .
=OR(A1=LARGE(range,{1,2,3}))
Biff "thechilipino" wrote in message ... hi h2000: one possibility would to use conditional formatting - 'formula is': =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(r ange,1)) hth. cheers. thechilipino. "Hubitron2000" wrote: Any ideas? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions | |||
Linear Mode
