Filter

Hi Nigel, thanks for your query. Not achievable without some code I'm afraid. You could conditionally format the contents of the cells to change to font colour white, but you can't use conditional formatting to change the structure of the worksheet.

Have a read of this for some indication of how you would use code to do this:

http://www.mrexcel.com/archive/Formatting/12131.html

Hope this helps,

Anthony