I have a table. I have a row with cells with a tickbox (formcontrol).

When I filter I can't distinguish between ticked and non ticked.

How do I do that?

CodePudding user response：

As a basic solution; you can do this by assigning checkbox value to a cell. For example you have a checkbox at A2 cell, select the checkbox (dont check just select with right click) and write "=C2" (or any other column) to formula bar. After that if you check checkbox C3 cell changes to TRUE. If you uncheck, C3 changes to FALSE. Then you can filter C column with True or False, and you can hidden C Column if you want. If you have too much checkbox, you can use a macro to assign the mapping.