| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Filtering with cell format
Hi,
I wonder in excel functions or excel VBA, is there anyway that those cells being highlighted by colors,fonts bold ( ie via cell format) in certain columns of database, can be filtered row by row with category, say 1st category is red font bold with yellow pattern 2nd category is just light blue pattern 3ed category is font italic bold or underline The result is to be seen same as auto-filtering functions. Thanks Regards Lenard |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Filtering with cell format
Filter work on cell values, so you would need to write User Defined
functions that evaluated the color of the target cells and return the category. Then put this function in the next available column on each row with reference to the cell to be evaluated for that row. Then filter the category returned. If the coloring is produced by conditional formatting, then you would just duplicate the conditional formatting formula in a dummy column with an adjustment to have it return the proper category. Then filter on this column. -- Regards, Tom Ogilvy "ltong" wrote in message om... Hi, I wonder in excel functions or excel VBA, is there anyway that those cells being highlighted by colors,fonts bold ( ie via cell format) in certain columns of database, can be filtered row by row with category, say 1st category is red font bold with yellow pattern 2nd category is just light blue pattern 3ed category is font italic bold or underline The result is to be seen same as auto-filtering functions. Thanks Regards Lenard |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Filtering with cell format
Hi Tom,
Thanks for your suggestions and kindly devise an excel VBA code ( ie UDF) to run the situation with a simple example include the following conditions : - say 1) 1st category is red font bold with yellow pattern 2) 2nd category is just light blue pattern 3) 3rd category is font italic bold and underline Regards Lenard "Tom Ogilvy" wrote in message ... Filter work on cell values, so you would need to write User Defined functions that evaluated the color of the target cells and return the category. Then put this function in the next available column on each row with reference to the cell to be evaluated for that row. Then filter the category returned. If the coloring is produced by conditional formatting, then you would just duplicate the conditional formatting formula in a dummy column with an adjustment to have it return the proper category. Then filter on this column. -- Regards, Tom Ogilvy "ltong" wrote in message om... Hi, I wonder in excel functions or excel VBA, is there anyway that those cells being highlighted by colors,fonts bold ( ie via cell format) in certain columns of database, can be filtered row by row with category, say 1st category is red font bold with yellow pattern 2nd category is just light blue pattern 3ed category is font italic bold or underline The result is to be seen same as auto-filtering functions. Thanks Regards Lenard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| Conditional format - another cell | Excel Worksheet Functions | |||
| conditional format cell | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown | Excel Programming | |||
Hybrid Mode
