Aug 11 2022 08:42 AM
How do I create a table from a large spreadsheet of raw data in which color fills per cell are utilized to signify different projects (for filtering] without losing the fill colors in the table? Excel 2016. Thank you.
Aug 11 2022 08:53 AM
As far as I know, fill colors are preserved when you convert a range to a table. Only cells that have No Fill will use the table style coloring.