How do I not show certain Letters in a range of cells in excel?
 

I'm creating a huge excel file to show all of our employee's vacation. Each
employee has their own worksheet and the last worksheet in the file is a
complete calendar of everyone and when they are on vacation. This last
worksheet is the only worksheet that gets sent out to all the employee's.
Now my problem is that when the employee's are sick I put in an S. So now
all the other employee's can see when that person was sick. I want to know
if I can just in that last worksheet make any cells that have an S in them to
be blank. Anyone know how to do this??? Any suggestions would be great.

How do I not show certain Letters in a range of cells in excel?
 

Hi Taryn

One way, use Conditional Formatting to set the cells containing "S" to
have White font on White background.
FormatConditional FormattingCell value is.="S" Set Format Font White
--
Regards

Roger Govier


"Taryn McGregor" <Taryn wrote in
message ...
I'm creating a huge excel file to show all of our employee's vacation.
Each
employee has their own worksheet and the last worksheet in the file is
a
complete calendar of everyone and when they are on vacation. This
last
worksheet is the only worksheet that gets sent out to all the
employee's.
Now my problem is that when the employee's are sick I put in an S. So
now
all the other employee's can see when that person was sick. I want to
know
if I can just in that last worksheet make any cells that have an S in
them to
be blank. Anyone know how to do this??? Any suggestions would be
great.

How do I not show certain Letters in a range of cells in excel?
 

Make a copy of the worksheet.
Remove the "S" before sending it out.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Taryn McGregor"
<Taryn
wrote in message
I'm creating a huge excel file to show all of our employee's vacation. Each
employee has their own worksheet and the last worksheet in the file is a
complete calendar of everyone and when they are on vacation. This last
worksheet is the only worksheet that gets sent out to all the employee's.
Now my problem is that when the employee's are sick I put in an S. So now
all the other employee's can see when that person was sick. I want to know
if I can just in that last worksheet make any cells that have an S in them to
be blank. Anyone know how to do this??? Any suggestions would be great.