use an if formula to fill cells with color

[Parker]

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

 

[curious engineer]

I will assume that the data begins in A1,B1,C1,D1 even though those probably
have the column titles in them.

C1 and D1 need to be selected here and go to the Format menu and select
conditional format. The drop down menu should default to Cell Value Is. You
need to change that to Formula Is.

Type the following into the formula box
=AND($B1="Yes")
Then choose the format to fill in black.

This is assuming you have Yes in column B if they still work there, if not
whatever word you use is to be used in the formula as well. You can then copy
this to all cells in column D and the rest of the cells in column C.

Hope this helps

 

[T. Valko]

I am using excel 2007

Assuming column B contains Y or N

Assume the range of interest is C210

Select the range C2:C10
Home tab>Styles>Conditional Formatting>New Rule>Use a formula....

=$B2="N"

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