Forum Discussion
Filter function help
Hi, I am in the process of updating and managing our work projects log. As you will see from attached document I have merged rows at the beginning of the table to allow each project to include a...
MalcolmBrowning One good reason not to use merged cells. They often cause trouble. Just like you have discovered now. Consider to un-merge the 4 cells, repeat the percentage in each of them and use conditional formatting to have the font colour blend in with the back-ground. Basically similar to how you coloured the first column now. Then you can filter as desired.