Changes subject line
When I receive a word doc from one particular person, open
it and make modifications and send back as a reply, it
changes the subject line to a very old message that has
been deleted for months. It always changes to the same
old subject line and only happens when sending to one
...can "if" formula be used to change cell formatting?
can cell formatting conditionally change based on what the cell value
is by using an "if" formula?
basically what i am after is:
if value in cell A1="x" then cell A1 font color is red, else cell A1
font color is black.
if an x is input, it turns red, if anything else is input, it is
i do not want to do this with a macro since i want the cell formatting
to change immediately upon editing the cell value.
can this be done?
thanks for your time!
Message posted from http://www.ExcelForum.com/
you may have a look at 'Format - Conditional...Daylight Savings Changes for Commonwealth Games
I am still on NT4 domain. My Exchange 5.5 servers & OWA 5.5 server runs on
Windows 2000 operating system. As far as I know, there is no patch availabe
for Exchange 5.5. How? Am I going to face problem if not doing anything? What
happen if the user apply the patch on their workstation? Please advise,
On Sun, 19 Mar 2006 16:16:26 -0800, seeker01
>I am still on NT4 domain. My Exchange 5.5 servers & OWA 5.5 server runs on
>Windows 2000 operating system. As far as I know, there is no patch availab...save changes when no changes made
When I go to close an Excel document, I am asked about saving changes even
though none have been made. I have already searched this question here and
every suggestion has not helped. I do not have any macros in the workbook,
no links to any other workbooks and it does not have any functions that may
cause this (I know that TODAY(), NOW(), etc.) can cause this.
Any suggestions to find what I have stuck in the file or a setting wrong? I
have Excel 2002
If the workbook was created in an earlier version of excel, then xl2002 will
recalculate it when it opens.
And then when you close th...Change Track Changes Colour
Is it possible to change the colour that Excel 2003 Track Changes appears
in? It's currently showing up as navy which is difficult to identify against
I want to change the background color of a field when certain conditions are
true. Can someone please advise me what the syntax is? I am currently using
the code below which only makes the border colour to be red. I would really
appreciate some help.
var r = crmForm.all.new_field.DataValue;
var d = crmForm.all.new_field1.DataValue;
if (r!= null)
crmForm.all.new_field.style.backgroundColor = "#FF0000";
crmForm.all.new_field.Color = "#FF0000";
crmForm.all.new_field.style.backgroundColor = "#FF0000";
With...How to change saving from My documents to another place?
Every time I save my work I am directed to My Documents. I want to save in
another place. How do I do that?
What version of Publisher are you using?
"Blair" <email@example.com> wrote in message
> Every time I save my work I am directed to My Documents. I want to save in
> another place. How do I do that?
Tools, Options, general tab, change the location...
Mary Sauer MSFT MVP
"Blair" <firstname.lastname@example.org&g...Changing the colour of a comment?
I want to know in Excel 2003, when I enter in a comment the cell is flagged
with a red indicator in the top right hand corner. Is there a way that I
can change the colour of the indicator?
Rob, no need to post to more than one group, must people look at all of
I don't think this is possible
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Rob" <email@example.com> wrote in message
new...CArchive error in IMPLEMENT_SERIAL
I working in a project in VC++6.0 .I am using nearly 20 classes , in
that nearly 5 class are derived from Cobject .I have implemented
serialization . When I use object of one class (derived from Cobject )
in another .I got a error saying that
Error C2679: binary '>>' : no operator defined which takes a right-
hand operand of type 'class CAlertSent *' (or there is no acceptable
For this line : archive >> nextSentAlert;
So I added this line.in the file where I am using that CAlertSent
IMPLEMENT_SERIAL(CAlertSent,CObject,VERSIONABLE_SCHEM...Change in account's form automatically updates contact's form
How to make so that during a change (i.e address) in the account's form that
automatically updates the change in the contact's form associated on this
You need a callout to do it. Look at
http://www.stunnware.com/crm2/topic.aspx?id=Callout1 which is exactly what
you're looking for.
"fabrice" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:2288C155-5E58-459B-9CBD-035036B...An example from a book is method NewFloorRequest in the right class
Below is an example from a book. The books is position method
NewFloorRequest in class Person.
What is your opinion about that in this example ?
How should I think here ? If I think who is pushing the button then it's
the Person and so it should be in class Person.
I also mean that it belong more logically to class Elevator.
Can somebody give me a guideline how I should think when trying to find a
suitable class for method
private int currentFloor = 1;
private int requestedFloor = 0;
private totalFl...applying changes across pages
Newbie to Publisher Question Follows :) :
How do I edit ....let's say the Home page of a premade website in publisher
and remove an object and have that change apply to all the pages.
I seem to be able to change the contents of the premade pub site text box
and have it apply to all the pages on the site . If I delete the Object it
only applies to that one page .
ANY HELP GREATLY APPRECIATED!
Please refer to your posting in the correct forum of webdesign.
FYI, one post in one group is sufficient.
David Bartosik - MS MVP
for Publisher help:
enter t...OWA 2003 Change Password Issues
I am working with:
Windows 2003 Standard SP1
Exchange 2003 Enterprise SP1
I have recently installed the above products on a new server and the install
went great. No errors, no issues. All is working well except for the change
password function in OWA. I turned on the change password feature and it
appeared as it should. The first thing I noticed is that when I selected the
change password button, the domain would not be automatically populated like
it should and I could not change my password. Everything I found on the
Internet pointed me toward hot fix 833734. I contacted Micros...When i change ComboBox, my textboxes should change accordingly, ho
I have a form with 4 items.
When i change ComboBox (ID)
i want my textboxes to change accordingly to show thier corresponding Name,
Nationality and Department.
How can this be done using a form.
Please let me know the steps. Thanks a lot exerpt !
Allen Phailat Wongakanit
"ali" <email@example.com> wrote in message
>I have a form with 4 items.
> When i change ComboBox (ID)
> i want my ...Code to change part of a formula across worksheets
Hi all - I hope someone can help with this...
I have formulas that include links (not hyperlinks) in their calculations e.g.
Cell A5 formula is:
='C:\Documents and Settings\Bob.JOB-Bob\My Documents\Bob
Personal\Inventors\Meetings\[XClient Plan for Restructuring and Rebudgeting
as at 06_10_09.xls]Detailed Report'!$U$18+$C83
I need a macro to prompt the user to enter the OLD workbook name into an
input box e.g. [XClient Plan for Restructuring and Rebudgeting
as at 06_10_09.xls]
The code looks for all cells with that string and then replaces it with the
new workbook na...how to change PROPSHEETPAGE_V3 to V2?
When I define _WIN32_WINNT to 0x0500, the struct PROPSHEETPAGE is suppose to be
PROPSHEETPAGEA_V2. But when I'm debugging, I find it is using PROPSHEETPAGEA_V3.
Why? Should I define other flags to carry out it? Thanks!
How do I change the name that is in the microsoft.public.excel.misc column
Since you use outlook express you have to do it there
tools>account and select the news account in question and click properties
then change the name
"Roger Bedford" <firstname.lastname@example.org> wrote in message
> How do I change the name that is in the microsoft.public.excel.misc column
...Sudden change in "Sent" folder
Yesterday, my "Sent" folder showed sent messages listed
by the addressee, that is, the first column was "To."
Suddenly this morning, it says "From" and I have no idea
how to find a message by the recipient! This is a major
You probably changed the view on your Sent Items folder by mistake. The
default view for the Sent Items folder is "Sent To". Change it via View |
Current View, or enable the Advanced toolbar and use the Views dropdown box.
MVP - Outlook
*** Messages sent to my e-mail addres...IMPLEMENT_SERIAL for nested classes
Anyone aware of a way to get serialization to work for nested classes? I'm
having a tough time figuring out how to properly utilize the
IMPLEMENT_SERIAL for a class which is nested.
Does anyone know if I can customize the charts or reports
on the homepage. For example the income vs expense report
is based on all accounts and categories. I would like to
customeize this graph.
Any help is appreciate.
...Using Formulas to Change Colors
Can you use formulas to change the shadow of the cell when certain
conditions are met? I am very good using Excel, but have never tried this
and I cannot find any documentation. So, I think that it just cannot be
Microsoft MVP - Excel
"Dave Jacoby" <email@example.com> wrote in message news:%1Tmh.14861$U12.firstname.lastname@example.org...
| Can you use formulas to change the shadow of the cell when certain
| conditions are met? I am very good using Excel, but have never tried th...Change info order
I need to reverse this info, please!!.
This is the original DATA
A B C D
1 C=D3DIGO 74475 74471 74469
2 1010046 2 5
3 1010800 0 1
4 1010169 5 1 0
5 1011031 4 2
6 1010111 0 0 5
And I need this to show up
A B C
1 C=D3DIGO CANTIDAD LOCAL
2 1010046 2 74475
3 1010169 ...Publisher 2007 Print Setup Margins & Gaps change when changing pri
I'm trying to print business cards on a printer that is not my default
printer. In the Print Setup | More Print Options dialogue box I have the
margins set as follows when my default printer is selected:
Side Margin: 0.7"
Top Margin: 0.44"
Horizontal Gap: 0"
Vertical Gap: 0"
However, when I switch to my color printer (not the default printer) the
margins and gaps change. I cannot find a way to save them, and I can't change
my default printer as it's set in the group policy for my system. It's
amazingly tedious to change all four settings every time I ...Change Track Changes default options
Track Changes defaults to tracking format changes as well as substantive
ones. Is there a way to change the default to not track format changes so it
doesn't have to be changed each time I use Track Changes?
You can try turning it off in the normal.dotm template, and some
people find that it sticks. I find that it turns itself back on
On Dec 9, 11:15=A0am, coffent <coff...@discussions.microsoft.com> wrote:
> Track Changes defaults to tracking format changes as well as substantive
> ones. =A0Is there a way to change the default to not track format changes=
...Price Change on the Customization Table
We have a customization application in the GP. One of the major function is
to provide more flexible pricing, which will set a different price for
But when it comes to price change, it takes way long to change the price
because we have to do them for every single customer.
Is there a better way to do it? I am thinking of Integration Manager, but
IM can not handle the custimization table.
We have a Excel sheet to record the price change, I am thinking of a way
that can update the table based on the Excel spreadsheet.
Basically the info on the spreadsheet...