#1   Report Post  
Kristin N
 
Posts: n/a
Default select by color

How can I select specific cells that have been colorized. Once selected I
want to move these to a different column.
  #2   Report Post  
Bill Martin
 
Posts: n/a
Default

Kristin N wrote:
How can I select specific cells that have been colorized. Once selected I
want to move these to a different column.



Chip Pearson has a bunch of functions to handle colored cells:

http://www.cpearson.com/excel/colors.htm

Bill
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can you select rows in excel with a certain background color? stelee Excel Worksheet Functions 1 August 3rd 05 04:04 PM
In Microsoft Excel 2003, when I select a color for a cell it does. Jude Excel Worksheet Functions 3 March 13th 05 04:55 PM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 05:27 PM
Select or Filter by Fill Color Wil Excel Worksheet Functions 1 November 4th 04 10:03 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"