Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filtering list based on formating
hi
is there a way to filter a list based on the format of the cells say 'highlighted in red' or font or something like that. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filtering list based on formating
If you built a UDF that examines this property, then you can add a dummy
column next to your data with this function and filter on the results of this function. Assume data is in A2:C25 and you want to filter on a background color of Red (not produced by conditional formatting) for column A. Put the below function in a general module (insert=Module in the vbe), not a sheet or the thisworkbook module. Public function ShowColor(rng as Range) ShowColor = rng.Interior.ColorIndex End Sub In D2 put in the formula =Showcolor(A2) then drag fill down to D25 in D1 put in the header Color then apply the autofilter and filter on the value 3. (colorindex for red is 3). -- Regards, Tom Ogilvy Keyur wrote in message ... hi is there a way to filter a list based on the format of the cells say 'highlighted in red' or font or something like that. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating multiple cells in 1 row based on a list of d | Excel Worksheet Functions | |||
How- seperate a combined list by filtering out first list of names | Excel Worksheet Functions | |||
list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |