The reason I want to keep the formula is so that I can still filter by true or false in the columns.
i.e. I can go to a folder and filter by TRUE to see who has access to that folder.
I do not know of a way to just filter by the colour of the cell- I dont think that is possible(?) so keep the cell content for filtering btu it looks neater is there are no '#' symbols.
Thanks again for the help
Bookmarks