Solve Excel's inability to copy cell formatting via formulas by using VBA or conditional formatting to display values with inherited styles.