Forum Discussion
Filter dynamic Array keep source formatting.
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
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