Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filter option.
I have some text in different cell with different background color.
I want to see the cells which has common background color. Is there any filter option in excel to those cells. |
#2
|
|||
|
|||
No, not yet (it's on Ron's EasyFilter to do list).
Add a helper column and a UDF. The UDF would be Function ColorIndex(rng As Range) ColorIndex = rng.Interior.ColorIndex End Function add this i the helper column =ColorIndex(A1) and copy down Then filter on the helper column If you don't want to remember the colour index codes, use something like =ColorIndex(A1) = ColorIndex($A$1) where the second part refers to the cell colour you wish to test. This will return True or False for all cells, and filter on that instead. -- HTH RP (remove nothere from the email address if mailing direct) "vishu" wrote in message ... I have some text in different cell with different background color. I want to see the cells which has common background color. Is there any filter option in excel to those cells. |
#3
|
|||
|
|||
Hi Bob
No, not yet (it's on Ron's EasyFilter to do list). This is the first thing I add to the Add-in Bob Seems to be a hot item -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... No, not yet (it's on Ron's EasyFilter to do list). Add a helper column and a UDF. The UDF would be Function ColorIndex(rng As Range) ColorIndex = rng.Interior.ColorIndex End Function add this i the helper column =ColorIndex(A1) and copy down Then filter on the helper column If you don't want to remember the colour index codes, use something like =ColorIndex(A1) = ColorIndex($A$1) where the second part refers to the cell colour you wish to test. This will return True or False for all cells, and filter on that instead. -- HTH RP (remove nothere from the email address if mailing direct) "vishu" wrote in message ... I have some text in different cell with different background color. I want to see the cells which has common background color. Is there any filter option in excel to those cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter option | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions |