Forum Discussion
Filtering in Excel using a Table
First - Is there a way to format a table in Excel where you can hide redundant cells, but maintain the ability to filter for the data I need? Example: Here the three instances of the Perso...
You can conditionally format the font colour to match the cell fill colour.
That only changes the visual appearance of a flat data structure. If you wish to have one to many links using foreign keys that would require considerable effort to set up and maintain in Excel.