If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering throough cell color
Hi is there any way by which we can filter the rws by choosing the color of a
cell. |
#2
|
|||
|
|||
Filtering throough cell color
In 2007 you can.
Before that you must use VBA unless the cells are colored due to Conditional Formatting. Then you filter on the condition. Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 10:29:02 -0700, Radhakant Panigrahi wrote: Hi is there any way by which we can filter the rws by choosing the color of a cell. |
#3
|
|||
|
|||
Filtering throough cell color
Hi
Only in XL2007, unless you write a macro. -- Regards Roger Govier Radhakant Panigrahi wrote: Hi is there any way by which we can filter the rws by choosing the color of a cell. |
#4
|
|||
|
|||
Filtering throough cell color
And if you're using xl2003 or below, you can try Ron de Bruin's EasyFilter
addin: http://www.rondebruin.nl/easyfilter.htm Radhakant Panigrahi wrote: Hi is there any way by which we can filter the rws by choosing the color of a cell. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|