Forum Discussion
Filter function, custom format
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 Replies
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.
FILTER(), as any other function, returns values, not cell properties as format. You may apply desired format to the result using Format Painter.
