I have an excel worksheet where text data in some cells are changed to "red". I want that data to stay formatted "red" in any pivot tables created from that worksheet. Is this possible?
Example: Column "Hospital" has 25 entries. "General Hospital" font color is "Red". All other cells are black text. I create a pivot table and want "General Hospital" to always show in red text.
Example: Column "Hospital" has 25 entries. "General Hospital" font color is "Red". All other cells are black text. I create a pivot table and want "General Hospital" to always show in red text.