I have a list of items on which I used "Format as Table" to allow filtering and to have alternate color to more easily follow rows. On some columns I would like to use checkboxes from the Developer tab (Form Controls). I also did a "Cell link" to the cell in which the checkbox is located in. So this now allows me to filter on TRUE and FALSE. The issue I have is making TRUE and FALSE disappear. I tried to set custom formatting with ;;;. That did make TRUE and FALSE disappear but now I also can't filter on it anymore. There is no transparent font color. I could try to set the font color equal to the fill color (from the Format as Table) but that seems to require VBA which I try to avoid (not because it's difficult but because of security warnings). So is there another way to make the TRUE/FALSE disappear while still being able to use filters.
Bookmarks