Filter dynamic Array keep source formatting.

Copper Contributor

Hello I am using the Filter command to create a dynamic array.

Is there a way to have the results returned in their original source formatting "Bold" etc?

 

Thank you

Vince

3 Replies

@Vince-K1

Excel functions, including FILTER, don't work that way.

If you have specific rules for the formatting, you can use Conditional Formatting to format the result of the formula.

Functions do not return the formatting of the cells the value is taken from I'm afraid. To "mark" items in a table of values, it is better to use an additional column in which you enter -say- a 1 or a 0 then by marking them using things like Bold, or a cell color. You can then make the rows in question change their display format by using a conditional format based on the value of the newly inserted column

@Vince-K1 Thank you all for you reply's