Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T-Diego
 
Posts: n/a
Default Can search by cell format like fill color?

Can cells be selected from a series of spread sheets by only the cell's fill
color so that all such entries can then be transferred to a single new sheet?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Can search by cell format like fill color?

Ron de Bruin's EasyFilter add-in probably does all that
http://www.rondebruin.nl/easyfilter.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"T-Diego" wrote in message
...
Can cells be selected from a series of spread sheets by only the cell's

fill
color so that all such entries can then be transferred to a single new

sheet?


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
fill cell with color from other worksheet Crakel Excel Discussion (Misc queries) 4 April 19th 06 05:14 AM
I want to fill the cell color based upon the other cell condition sri Excel Discussion (Misc queries) 4 January 12th 06 01:47 PM
How do I use cond format formula to set cell text and color? sbwilliams Excel Discussion (Misc queries) 4 January 8th 06 10:20 AM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM


All times are GMT +1. The time now is 06:38 PM.

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"