| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select only colored cells
How can I select only cells that are colored in yellow in Excel?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Select only colored cells
What exactly are you trying to do? If you want to find a cell that is
colored, you can do a find, and then under options, format.... "BBlue" wrote: How can I select only cells that are colored in yellow in Excel? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Select only colored cells
I am sorry I wasn't clear enough. Let me put it in an example:
I have a spreadsheet full of information. Cell types vary from text, dates, dollar amounts and general numbers. Based on external criteria, some cells have been manually colored. What I need is to be able to pull all the cells that are of a particular color to a different section of the spreadsheet. I hope this helps clarify the question. Thank you for your responses. -- I don''t want to achieve immortality through my work. I want to achieve it through not dying. "Difficult1" wrote: What exactly are you trying to do? If you want to find a cell that is colored, you can do a find, and then under options, format.... "BBlue" wrote: How can I select only cells that are colored in yellow in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro €“ select all cells in current range | Excel Discussion (Misc queries) | |||
| How do I select individual cells for a chart | Charts and Charting in Excel | |||
| is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions | |||
| New - Help - select cells + Free Tutor | 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 | |||
Hybrid Mode
