| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Select or Filter by Fill Color
Hi,
Does anyone know how to select a range of rows/column while they were tagged by Fill Color? For example, A1 to A3, and A10 to A15 have Fill Color Green A4 to A6, and A7 to A9 have Fill Color Red Then, I want to filter/select only the Red and paste the values in a different workbook. Is there any work-around to do these or a VBA script available that somebody can share? Thanks in advance. -Wilfredo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| Inserts and color fill | New Users to Excel | |||
| A different "Fill Color" problem | Excel Worksheet Functions | |||
Threaded Mode
