Solved In Excel I want a list of Employees down the left and

Microsoft Office 2007 professional (aca...
October 19, 2012 at 10:56:38
Specs: Windows XP
2 columns with a headings of IN and OUT
I want to simply type and X for the employee that is IN and if he leaves I type an X in the OUT, but I want Excel to automatically remove the X from the IN column and vice a versa.

Office 2007

See More: In Excel I want a list of Employees down the left and

Report •

October 19, 2012 at 11:44:59
✔ Best Answer
Try this:

With your data like:

       A              B     C
1) Name               IN   OUT
2) GearJammer               X

The default behavior is to always be OUT
so, enter this formula in cell C2:


Then when you enter an X in cell B2 (IN),
C2 (OUT) goes blank.

When you delete the X in B2 (IN),
C2 (OUT) displays an X.


Report •

October 19, 2012 at 11:48:58
Thanks for letting us know what you want.

If you need some help with that, feel free to ask.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 19, 2012 at 12:08:04
Wow, works like a charm. Thanks!

PS, can you turn on green highlights if they are in and red if they are not?

Report •

Related Solutions

October 19, 2012 at 14:08:22
Try this:

You will need two rules:

First rule for Green:

1) Select your cell B2
2) On the ribbon click Conditional Formatting
3) Click on Highlight Cell Rules, at the top of the dialog box.
4) Click Equals To from the list
5) In the box under the words Format Cells That Are Equal To: Enter the letter X
6) The second box, to the right, should be defaulted to: Light Red Fill with Dark Red Text Click on the drop down arrow, and at the bottom of the drop box and select Custom Format
7) Select the Fill Tab
8) Select Green color
9) Click OK
10) Click OK

Now when cell B2 contains the letter X, it will turn Green.

Think you can work out how to turn cell C2 Red?


Report •

October 20, 2012 at 17:15:59
Please ignore this and excuse me for interrupting.

What's the trick for inserting extra spaces on the forum (as in #1)?
If I put just one extra space in it always gets removed.

Or are they tabs?

Report •

October 20, 2012 at 17:46:29
You need to use the PRE Tags, see this How-To:

It take a bit of fiddling when you first use them, but get's easier the more you do it.
I always use just spaces, tabs can get confusing.


Report •

October 20, 2012 at 19:23:08
Thanks a lot mmcconaghy. I've bookmarked it and will get stuck into it later.

Report •

October 22, 2012 at 03:54:37

Thank you so much! It seems like Excel can do almost anything. Thank you for your help it works great!


Report •

Ask Question