I am creating a table to show employees new and old,
in colum A I have the employee name in colum B I have whether or not they
are still working for the company and in columns C and D I have information I
would like to hide by filling black if they don't work with us anymore.

I am using excel 2007, I would greatly appreciate any help you could provide
in the means of a formula to accomplish this.

Thank you