Thanks!
Forum Discussion
Excel: How to add a color search option to filter menu when there are more than 10,000 rows
I use PHPSpreadsheet to generate Excel spreadsheets that have over 10,000 rows. I use green background color for cells in the "default translation" column to indicate the translation is newer than a custom translation item in a different column (same row). If the first green cell is after row 10,000 then the 'Sort by color' has no green color choice and the 'Filter by Color' option is disabled. Is there a way to add a custom color choice to the filter menu? I've seen suggestions to add a row near the top with the green color but this is not practical because the spreadsheet might be sorted on another column causing the green cell to go past row 10,000 and removing the green color option from the filter menu. I am currently using PHPSpreadsheet to generate the Excel document. I want users to be able to easily sort or filter on the green color without having to add the color themselves.
2 Replies
- I would take an entirely different approach and rather than using color, just use a value in a cell to indicate a change. If needed, use an extra column. Excel is far more efficient in working with values than with formatting.
JKPieterseGood point, I was trying to avoid this because I already have so many columns. I could make them hidden and create a button to sort it ... -thanks
