[mso] Re: (No Date: Wed, 18 Aug 2004 22:52:20 +0200

Hi,

To start with, the names on that piece of paper have to be written to
a sheet somewhere. This is nessesary or you may as well forget any
automation.

Conditional formatting may be appropriate for the supervisor names in
column A but with the deleting of cells I'm not sure that will work...
If I have a conditionally formatted cell and delete cells above and
below it does it retain its' conditional formatting.. I'll experiment
with that but maybe Ray can jump in here.

From all of these posts I think that there is actually nothing in
column B at all. Is this correct?

> At the end of the names there is a cell for A and B that is not
merged but is outlined so you can see that they are
> separated boxes..

I'm sorry for appearing so stupid but I don't understand this at all.
Do you mean something like this...

ColA                     ColB      ColC
Supervisor Name
Yellow if in Col F

Employee Name
-Merged/Green------------------    Outlined


Lisa

> 1) Currently I run a report in another program to find the names.
> I then past them into Column F.
> 2) Currently I have to look on a piece of paper I wrote up
> that says which
> employees are under each supervisor.
>
> 3) To begin with every supervisors name is already on the
> list in column A.
> If their name appears in column F it will be yellow, if not
> it will not be
> highlighted.
>
> 4) Column A and B are merged where the names are placed. At
> the end of the
> names there is a cell for A and B that is not merged but is
> outlined so you
> can see that they are separated boxes, then it goes to the
> next supervisor
> on the list and so on.
>
> *I know this is strange but I have to keep this format.
> Thank you for your
> help.


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: