| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter specific cells by hughlighting
I am trying to filter 4 specific cells from an excel spreadsheet. The value
within the cell is similar to other values so I cannot sort by that alone. I need to specifically sort by the cell (i.e. B8, B9, K8, K9). Also, is it possible to simply have them "highlight" to show they are selected? Thank you so much for your help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter specific cells by hughlighting
Set SortRange = Range("B8, B9, K8, K9")
SortRange.Interior.ColorIndex = 3 "bchase" wrote: I am trying to filter 4 specific cells from an excel spreadsheet. The value within the cell is similar to other values so I cannot sort by that alone. I need to specifically sort by the cell (i.e. B8, B9, K8, K9). Also, is it possible to simply have them "highlight" to show they are selected? Thank you so much for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter with a specific character | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| Continuous hughlighting of cells | Excel Discussion (Misc queries) | |||
| How do i total a specific sum, using the filter? | New Users to Excel | |||
| Form a circle (ie. color specific cells) given specific radius | Excel Programming | |||
Linear Mode
