Conditional Formatting by name on seperate worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Supe - 15 May 2007 14:28 GMT

Is there a way to set up conditional formatting where if a name is entered
that is on a list on a seperate workssheet that cell will shade to a selected
color? For example, on worksheet #1 I have a list of 200 names, one which is
Jeff Restad. If I enter that name in worksheet #2, that cell will shade to a
selected color in worksheet #2.

Reply to this Message

fredg - 15 May 2007 16:55 GMT

> Is there a way to set up conditional formatting where if a name is entered
> that is on a list on a seperate workssheet that cell will shade to a selected
> color? For example, on worksheet #1 I have a list of 200 names, one which is
> Jeff Restad. If I enter that name in worksheet #2, that cell will shade to a
> selected color in worksheet #2.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message