Filter function, custom format

[joakimjernbro]

Hey

I´m using the =filter function to copy rows with a specific value to another worksheet.

It works great but I want to use a custom format in some of the cells and the filter function does not copy the custom format to the other worksheet.

Example:

C4 contains editable numbers with a custom format that adds the word "pcs" after but C5 contains editable numbers with a custom format that adds the word "hours" after

Is it possible for the filter function to bring those custom formats to the other worksheet?

[#2]

@joakimjernbro 

FILTER(), as any other function, returns values, not cell properties as format. You may apply desired format to the result using Format Painter.

[#3]

@joakimjernbro 

Custom number formats can be applied to spilt ranges using conditional formatting.  If the format depends on the content (e.g. less than 1 is a time whilst integers greater than 1 are part counts) that is easy but if it depends on a separate criterion then you would need to output a filtered copy of the criterion to a helper range.