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...
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.