I just wanted to ask if there is a way of crating a macro of something like
that with Excel.
I need to feel a whole excel file with names, and they will be sorted by
numbers. Then I want to have a window that will have a place where I will put
a number in. Automically the person with the same number will be ticked(or
change the color of the cells) so that I will know who I have checked in.
Please I need your assistance.
Thanx

sounds like you want conditional formatting using the formula is option. In
the formula box you would use something like
A B
1: Number Name
2: 1 Smith

Assume the number to be entered is on a sheet name EntrySheet in cell B9

Select A2 to B200 (for example) with A2 as the activeCell.

Do format=Conditional Formatting, and change Cell Value is to Formula is.
In the formula text box put

=$A2=EntrySheet!$B$9

--
Regards,
Tom Ogilvy

"alhadschi" wrote in message
...
I just wanted to ask if there is a way of crating a macro of something
like
that with Excel.
I need to feel a whole excel file with names, and they will be sorted by
numbers. Then I want to have a window that will have a place where I will
put
a number in. Automically the person with the same number will be ticked(or
change the color of the cells) so that I will know who I have checked in.
Please I need your assistance.
Thanx

"You may not use references to other worksheets or workbooks for Conditional
Formatting criteria"

That's the message I get, by doing what you told me to do.

Thanx

"Tom Ogilvy" wrote:

sounds like you want conditional formatting using the formula is option. In
the formula box you would use something like
A B
1: Number Name
2: 1 Smith

Assume the number to be entered is on a sheet name EntrySheet in cell B9

Select A2 to B200 (for example) with A2 as the activeCell.

Do format=Conditional Formatting, and change Cell Value is to Formula is.
In the formula text box put

=$A2=EntrySheet!$B$9

--
Regards,
Tom Ogilvy

"alhadschi" wrote in message
...
I just wanted to ask if there is a way of crating a macro of something
like
that with Excel.
I need to feel a whole excel file with names, and they will be sorted by
numbers. Then I want to have a window that will have a place where I will
put
a number in. Automically the person with the same number will be ticked(or
change the color of the cells) so that I will know who I have checked in.
Please I need your assistance.
Thanx

Your correct about doing it direclty, but you can get around it by using
named ranges.

Create a name
Insert=Name=Define
Name: KeyCell
Refersto: =EntrySheet!$B$9

then click ADD.

then in the formula use

=$A2=KeyCell

--
Regards,
Tom Ogilvy


"alhadschi" wrote:


"You may not use references to other worksheets or workbooks for Conditional
Formatting criteria"

That's the message I get, by doing what you told me to do.

Thanx

"Tom Ogilvy" wrote:

sounds like you want conditional formatting using the formula is option. In
the formula box you would use something like
A B
1: Number Name
2: 1 Smith

Assume the number to be entered is on a sheet name EntrySheet in cell B9

Select A2 to B200 (for example) with A2 as the activeCell.

Do format=Conditional Formatting, and change Cell Value is to Formula is.
In the formula text box put

=$A2=EntrySheet!$B$9

--
Regards,
Tom Ogilvy

"alhadschi" wrote in message
...
I just wanted to ask if there is a way of crating a macro of something
like
that with Excel.
I need to feel a whole excel file with names, and they will be sorted by
numbers. Then I want to have a window that will have a place where I will
put
a number in. Automically the person with the same number will be ticked(or
change the color of the cells) so that I will know who I have checked in.
Please I need your assistance.
Thanx