I am using excel 2007

Assuming column B contains Y or N

Assume the range of interest is C2:D10

Select the range C2:C10
Home tabStylesConditional FormattingNew RuleUse a formula....

=$B2="N"

Click the Format button
Select the Fill tab
Select a nice shade of black
OK out

--
Biff
Microsoft Excel MVP


"Parker" wrote in message
...
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