formula to change color of a cell when date is over a year old?
I'm looking for a formula to change dates that I have in a row once they are
over a year old.
FORMAT | CONDITIONAL FORMAT
regards from Brazil
> I'm looking for a formula to change dates that I have in a row once they are
> over a year old.
Your title says to change the color once over a year but the post says
to change the date? To change the color use Conditional Formatting.
Change Cell Value Is option to Formula is. Use this in A1 (or where
your dates begin).
=DATEDIF(A1,TODAY(),"...MS GP Consultnat
We are looking to hire (3) FT Great Plains Consultant to work in the DC Metro
area. Local consultants perfered. Work is local as well. Interested?
Email me: firstname.lastname@example.org
...Copy all events from my old calendar into a new one??
How can I copy all my old events from an old PST-file into my new installed
I only want to copy the event's into the calendar!!
open it using file, open, outlook data store and drag the items you want in
the new calendar to the new calendar folder. Tip: by category view will make
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tips.net/
Outlook...How do i remove old server locations in meeting workspace?
I have a situation where our workspace server location has changed its url. A
lot of users have simply created a new server location using the updated URL
but some users are still confused when accidently trying to create a
workspace using the outdated URL. Is it possible to clear the list of server
locations or at least remove the outdated location?
...importing mail/folders from old computer to new
i just got a new computer. i have on a cd all
the "Identities" from my old computers microsoft outlook
2002. I have all these DBX files that contain all the
messages from my old computer and i dont know how to make
it so my new computer uses them, or merge them with my
new computer. sorry if thats confusing i'm not sure how
to explain it.
i just want all my messages that i had saved on my old
computer using the same version of outlook to be
transferred to my new computer using the same version of
outlook. i have the dbx files, how do i make this happen?
Jess...Old bills will not delete in budget
In my budget, I have bills showing up automatically that I have previously
deleted from the bill payment schedule. When I try to edit these transations,
nothing shows up. I am not given the option to delete them. How do I remove
them from showing up in my budget catagories?
I was able to do this by viewing the "bill calendar" and deleting the bills
They did not show up in the Bills and Deposits list but they did in the
Hope that helps.
> In my budget, I have bills showing up automatically that I have previously
>...transfer outlook datas from an old hard disk to a new computer
I changed my computer but From the old one remains only the hard disk . How
transfer the datas from outlook (adress book and mails) old hard disk to my
new computer ?
You can use personal folder. It contains contacts and mails. If you copy
that pst file, that means you transferred your datas.
...message too old
We run a exchange 2003 environment and one of my users recieved this
NDR after sending to an external account who she has sent to
successfully in the past.
What is the cause of this?
Subject: Delivery Status Notification (Failure)
The following message to <email@example.com> was undeliverable.
The reason for the problem:
5.4.7 - Delivery expired (message too old) [scmze003] '[Errno 54]
Connection reset by peer'
newadmin <firstname.lastname@example.org> typed:
> We run a exchange 2003 environment and one of my ...MEM DC
I am writing an mfc application that display dib`s to a window from a USB
camera, on the dib I am drawing a yellow rectangle (like this
pDC->Rectangle(0,0,100,100);) as overlay,
The problem is when the new dib arrived the OnDraw function redraw the
rectangle and it make it flickering!
can I draw the dib and the rectangle in memory before they display to the
screen and then display them to the screen so they will not flickered?
can you sent me a piece of code that done it???
Yes you would want to do that.
Create a DC and a memory bitmap and then draw onto that. When you p...Need old Internet Explorer Back
I am having a problem with my internet explorer. I accidentally downloaded
the newer version 8 of internet explorer and I wanted to download 7. Most of
my sites only work with 7 so now my sites aren't displaying correctly. HOw
do I get 8 off of my computer and put 7 on? When I try to put 7 on it says
it won't let me because a newer version is already on there. Please
Use Control Panel - Add Remove Programs - Remove "Windows Internet Explorer 8"
> I am having a problem with my internet explorer. I accidentally downloaded...old laptop dead
to give you as much info as possible:
i have the retail version (not OEM) of office home & student 2007.
it allows installation on 3 different computers.
i currently have it installed on 2 laptops.
one of the 2 laptops (with vista) has died. i purchased a replacement laptop
& have the connected the hard drive from the dead laptop to the new laptop
(with windows 7) via usb hdd enclosure. the dead laptop was where the i made
the original installation onto.
office is currently installed on one working laptop and the one dead laptop.
thats 2 of my allowed 3 install...Exchange DC Question
HI, If I have 1 DC and 1 Exchange on seperate servers. What happens if I
need to rebuild my DC? When I rebuild it, will I have to run something so
that I have the Exchange options Under user accounts in Active Directory
Users and Computers. This is a small home setup. If needed I was going to
setup a second DC using VMware.
David Ross <email@example.com> typed:
> HI, If I have 1 DC and 1 Exchange on seperate servers. What happens
> if I need to rebuild my DC? When I rebuild it, will I have to run
> some...old program, new program Publisher
I have MS Publisher 2003 on computer, My son instaled MS publisher 2.0a from
1991-1993 now when I try to open anything I have done on 2003 the old program
takes over and can not open the file. I haved looked for the older program to
uninstall but all I can find is the 2003 program. Can someone please help?!!!
two4ever2002 <firstname.lastname@example.org> was very recently
heard to utter:
> I have MS Publisher 2003 on computer, My son instaled MS publisher
> 2.0a from 1991-1993 now when I try to open anything I have done on
> 2003 the old program takes over and can no...Old mail sent after reboot
When I restarted our Exchange 2003 server old email was sent.
To be more precise two things happened. One is we get NDR “Could not deliver
the message in the time limit specified” Then I get another message stating
it was delayed and tracking shows the message just went out even though it
was sent days to weeks ago. Two I get NDR that are days to weeks old.
Needless to say I have some upset users that thought all their mail had gone
I found an old Microsoft article 329636, but settings were fine. Plus it was
for Exchange 2000 server.
Thanks for any help.
I want to add the la...how can i stop my old mails to be download in my outlook?
I want to startto useMicrosoft outlook 2007 with my existing gmail Id.
But I dont want to receive all old mails from my gmail account to my outlook.
please inform me what settings to do for receiveing new mails from today only
Please help me....
You need to check the options in GMail Help files to see what they offer for
leaving mail in their application.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Nikhil...delete old outlook
do i need to delete the old office 2007 before upload the new office 2007
Outlook must always be installed clean. You uninstall, not delete, the older
After a clean install, you must then create a new Outlook from scratch--even
with a clean install.
"PSand444" <PSand444@discussions.microsoft.com> wrote in message
> do i need to delete the old office 2007 before upload the new office 2007
...Old event procedure not working in Access 2007
Have a db created probably in Access 97, or earlier, that has worked in
access 2000 for 5 years just fine. After installing Office 2007 (left the
2000 versions of Access, Word, and Excel on the PC) I have a problem with
it. Double Click on the file name, Access 2000 opens the db ok and displays
the Main Form which has 4 command buttons. When I click on 3 of the 4
buttons I get the following error:
The expression On Click you entered as the event property setting produced
the following error: Object or class does not support the set of events.
· the expression may not result ...Display contents of printer DC
I have got a problem with display content of printer DC. It prints
properly, but in the window i can't see anything.
CDC MyPrintDC; // Printer DC
// Draw line for the printer
CDC* dc; // Window DC
CDC memoriDC; // Memory DC
CBitmap memBMP; // Bitmap
// Get DC of window
dc = this->GetDC();
//Create DC compatible with PRINTER
// Create bitmap from printer DC
memBMP.CreateCompatibleBitmap(&MyPrintDC, 500, 500...DC Usage Advice
My applications painting is getting more complex and I've been thinking
about drawing first to a memory DC before BitBlt'ing the bitmap to the
screen in order to prevent flicker.
However, speed is also very important for me and my testing showed that
writing first to a memory DC was slower by over 400%.
I've started thinking about maintaining the memory DC (along with a bitmap
the size of the screen) in memory for the life of my application in order to
prevent having to create one each time my application paints. But I'm
worried about, not only the amount of memory my applica...Removing old server address from Outlook 2003
I just changed web hosts. When I configured Outlook for the new mail server,
I removed the old server address form the e-mail accounts. I'm getting mail
OK from the new server, but the old server address still pops up when I log
in or access e-mail. I can cancel thru that pop-up; but I want to get it out
of there. The old server is no longer showing in the e-mail accounts lists;
so where do I go to get it out of there now?
Win XP Pro SP3...Dell Precision 360
Firefox (current edition)
Old mail host: Yahoo
New Mail host: Blue Host
This might indicate a corruption in you...how to get old imap mails
I have been using outlook express to get mails from my imap mail account.
Recently, I deleted all mails in my imap mail box after making a backup by
creating a new folder(A) and saving all mails into this folder, and setting
a new "maintenance folder(B) (through "option" menu in "tool" tap). Now I
have been trying to read those old mails from the folder(A), but I have not
been successful. Do I lost all those old mails ? If not, how do I get access
to the old mails? All I did was to save old mails to a directory A, and
delete all mails in imap, change the ma...Importing old MS Mail folders
I need to import the shared folders and global address book from an old MS
Mail postoffice. I have seen some discussions concerning migrating
mailboxes but very little at that. Can anyone point me in the right
...After restart exchange resends old email to clients
After I restart my exchange server (exch 2000) it will regenerate old email
and send them to my clients. It doesn't matter wether I gracefully shut the
system down or If it froze and I had to press the reset button. If any one
could let me know why this is happening and what I can do to correct the
problem I would appreicate it.
I guess your Exchange servert is reprocessing all queues... If it's
that, you can't do anything.
Are e-mails duplicated in Inboxes?
On Mon, 17 Jan 2005 06:41:05 -0800, "Anthony"
<Anthony@discussions.microsoft.com> wrot...Slow shutdown- Exchange2003 running on Svr2003 DC
I found KB887539 regarding the above. Seems that by applying all
the patches related to SBS2k3 SP1, we can resolve the issue of slow
shutdown. But if we are not running SBS but standard edition Winsvr2k3
(as DC) and Exchange on the same server, is there any way to resolve
this? Will the patch help? Just want have some inputs before I try anything.
On Tue, 08 Nov 2005 09:11:23 +0800, Garion Goh
> I found KB887539 regarding the above. Seems that by applying all
>the patches related to SBS2k3 SP1, w...Can I remove some old items from Great Plains?
Hi, I am running GP 8.
I have several skus in our system that are old, and no longer used.
The items have been discontinued, but they still show up in several
reports, and more importantly our POS system. IS there any way that we
can archive, or remove these old items.
The only solution I have found is to delete the transaction history
for the item then delete it, but from what I understand, if I open an
old invoice, it will not longer have the product name in it.
Any suggestions are appreciated.
Take a good backup of your company database to serve as a an archive (or you