Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter on a color of a cell
Dear Sir
if i have a column that contains a different Background cells color and i need to Filter using the colores is it possible to do so provided that i'm using Excel 2003 thanks & Best regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter on a color of a cell
Hi,
If the colour is arrived at by condirional formatting then you can put the same condition in a helper column and filter on that or you can instal this http://www.rondebruin.nl/easyfilter.htm Mike " wrote: Dear Sir if i have a column that contains a different Background cells color and i need to Filter using the colores is it possible to do so provided that i'm using Excel 2003 thanks & Best regards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter on a color of a cell
And a couple more links
http://xldynamic.com/source/xld.Colo...r.html#sorting http://www.cpearson.com/excel/SortByColor.htm HTH Martin wrote in message ... Dear Sir if i have a column that contains a different Background cells color and i need to Filter using the colores is it possible to do so provided that i'm using Excel 2003 thanks & Best regards |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to filter on a color of a cell
This process can only be done with excel 2003 macro and Vba.As sample, cells with lowercase in the column I did a yellow background color.I then apply the filter to these cells. You can view he https://netmerkez.wordpress.com/exce...in-excel-2003/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance Filter can be based on cell Color in Microsoft Excel | New Users to Excel | |||
auto-filter in excel but leave cell background color | Excel Discussion (Misc queries) | |||
excel should allow me to filter rows on basis of the cell color | Excel Worksheet Functions | |||
Is it possible to sort and/or filter by cell shading color | Excel Discussion (Misc queries) | |||
Filter by Color | Excel Discussion (Misc queries) |