Forum Discussion
Filter Function cell color copy
I am using the filter function "=FILTER(FILTER('Survey Status'!B1:K330,'Survey Status'!K1:K330=A1),{1,1,1,0,0,0,0,0,0,0})" This filter function is working great for my needs. But the cell information...
No, formulas just return values, not formatting.
If the colors in the source range are the result of conditional formatting, you can create similar rules for the range with the formulas.
If the colors have been applied directly, there is no easy way to copy them. It would require cumbersome VBA code.