FILTER Function Doesn't Display Formatting

[diderooy]

Hello,

I have a large worksheet (about 25MB on its own) of a table with 60k rows of data; certain columns in the worksheet have manually modified formatting (blue/red text, bold/italics) that is not subject to any sort of conditional formatting.

I created another sheet to arrange the data a little more pleasantly, hoping I could just build a simple macro to display a group's data without having to filter and unfilter every time. I used the FILTER function to display it (**** is that a slick formula!). However, it is not showing the manual cell formatting; everything is like plain text. Is there a way to make the second sheet table (using the FILTER function) display with the formatting used on the first shee's table?

My version:

 

[SanjayGMusafir]

Is there a way to make the second sheet table (using the FILTER function) display with the formatting used on the first shee's table?

To best of my knowledge that is a limitation with Filter Function so far.

Only way is use Format painter or better Copy and Paste Formats Only using paste Special to the entire Filtered Columns. This way It might (shall) copy and paste Conditional Format rules too. Most times such (coppied) Conditional Format rules and work well and at time behave clumsy and need to be re-addressed.

 

[diderooy]

Thanks very much! I was afraid that was the case, but couldn't find any other complaints like this...surprising to me that the FILTER function isn't more popular (though I guess maybe that's one reason why.

 

[Fluff]

No functions will return the format of a cell, they just return the value of the cell.

 

[diderooy]

UPDATE here for anyone who is having this problem:

Advanced filters were able to display the formatting of my master worksheet; getting them to work was a challenge for me because I'm a novice, but they did the trick.