[mso] Re: line and fill colour
- From: "Jim Hickey" <jim@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 24 May 2007 12:44:58 -0500
Did you look under conditional formatting. Occasionally it is used so =
that
when you add or remove lines, the formatting stays.
HTH
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Fitzmaurice, Ann E.
Sent: Thursday, May 24, 2007 12:38 PM
To: mso@xxxxxxxxxxxxx; mso@xxxxxxxxxxxxx
Subject: [mso] line and fill colour=20
hi=20
=20
have been sent a document where the contents of a cell haave been
highlighted , have amended but cannot remove the highlighting as the =
fill
and line colour are greyed out , can anyone help
=20
ann
=20
=20
Ann E Fitzmaurice
Medical Statistician
Immpact ,University of Aberdeen
Health Sciences Building
Foresterhill
Aberdeen, AB25 2ZD
Scotland
Tel: +44 (0)1224 553876=20
Fax: +44 (0)1224 555704
Email: <mailto:a.e.fitzmaurice@xxxxxxxxxx
<mailto:a.e.fitzmaurice@xxxxxxxxxx> > a.e.fitzmaurice@xxxxxxxxxx
________________________________
From: mso-bounce@xxxxxxxxxxxxx on behalf of pamobsby@xxxxxxxxx
Sent: Wed 23/05/2007 14:27
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel help
I am quite a novice when it comes to Excel, however I have set up a =
budget
database for my club There are 3 Cost Centres (Music, Singing and
Presentation) There are 5 people in the music team
I created a worksheet for each cost centre and enter all the details on
these three worksheets (Name, Expense Code, Date, Purchase Order =
Number,
Amount, Supplier, Description, Payment Method, File Date, Constructed =
Key
Field*) * Column that converts date "dd/mm/yyyy" to "mmm-yy".
I then created a "Monthly Summary" worksheet which gives me the total
monthly spend by Cost Centre and a Year To Date worksheet which includes
comparison of YTD figures for each cost centre against budget.
I am struggling to create worksheets for each of the music team to show
their individual spend by cost centre and month
Hope someone can help
phil
http://www.rac.co.uk <http://www.rac.co.uk/>=20
http://www.rac.co.uk/business
http://www.bsm.co.uk <http://www.bsm.co.uk/>=20
Any opinions expressed in this e-mail are those of the individual and =
not
necessarily the company. This e-mail and any attachments are =
confidential to
RAC and/or BSM and are solely for use by the intended recipient.=20
If you are not the intended recipient you must not disclose, copy or
distribute its contents to any other person nor use its contents in any =
way.
If you have received this e-mail in error please forward a copy of this
e-mail to "Security@xxxxxxxxx".
RAC Motoring Services: Registered England 1424399
VAT Reg No. GB 238640945
British School of Motoring Limited: Registered England 291902 VAT Reg =
No. GB
239505847 RAC Financial Services Limited: Registered England & Wales =
5171817
VAT Reg No. GB 238640945 Registered Office(s): 8 Surrey Street, Norwich, =
NR1
3NG
RAC Motoring Services and RAC Financial Services Limited are authorised =
and
regulated by the Financial Services Authority, both companies are =
members of
the Aviva group.
This e-mail and any attachments has been scanned for the presence of
computer viruses. RAC/BSM accept no responsibility for computer viruses =
once
this e-mail has been transmitted.
*************************************************************
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, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister
group. This group will not allow for posting of emails, but will allow =
you
to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for =
FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your =
email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
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, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister
group. This group will not allow for posting of emails, but will allow =
you
to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for =
FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your =
email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
No virus found in this incoming message.
Checked by AVG Free Edition.=20
Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007
3:59 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007
3:59 PM
=20
*************************************************************
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, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
