Apply format from original cell in new formula

[Vilep]

Hi
I have a table in a sheet. Some rows have various formatting, e.g. bold.
I want these data in another sheet, so I've made formula just referencing the cell e..g =Sheet1!A1 etc. for all cells from sheet 1. However, I also want to copy the original formatting per cell as I want to filter on this information, e.g. filter away all rows in bold in sheet 2.

Any idea on how to copy format from original cell, or other way to have an "original sheet" and in other sheet do manipulations on formatting from sheet 1?

Thanks

 

[Joe4]

Formulas can only bring over values, not formatting from the cells they are referencing.

If the formatting was originally applied via Conditional Formatting, you may be able to use the same rules on the new section as the old one to recreate the formatting.
Otherwise, you will probably need to use VBA to copy the formatting over (if you do not want to do it manually).

 

[Vilep]

Thanks. Noted.