Excel Functions #2
hi guys, just wondered if anyone knew which function i would use to do this,
because im fairly novice with excel:
Basically if the cell value is above 110 i want the cell to turn green
if the cell value is between 110 and 105 i want it to turn yellow
if the cell value is below 105 i want it to turn red
any help would be seriously appreciated. thanks
> hi guys, just wondered if anyone knew which function i would use to
> do this, because im fairly novice with excel:
> Basically if the cell value is above 110 i want the cell to turn gr...RMS 2.0 Integration Approach
I have Commerce Server 2009 in place and would like to integrate it with
RMS2.0. What are some ways in general that an external system can integrate
...Button/Macro Not Working, Help!
I have a macro that pulls up Report Manager and prints out pre-define
views. The macro works fine only after I use Report Manager the firs
time. If I exit my workbook and Excel, then return to it, th
button/macro does not function. Nothing happens until I manully us
Report Manager again. Is there a bug with this or am I missin
Message posted from http://www.ExcelForum.com
Post your code.
Gord Dibben Excel MVP
On Thu, 20 May 2004 08:38:55 -0500, baston
>I have a macro that pulls up Report Manager and prints out pre...Trouble Printing Checks #2
I'm using Money 2004. I have a list of checks to be printed, but no 'Print
Checks' on the left side panel. When I go the 'File' menu to print checks it
gives me a
"You don't have any accounts with checks to be printed." message.
What can I do?
> What can I do?
I would run a file repair to see if that will correct the number do indicate
the number of checks that have been set to "print".
"David" <David@discussions.microsoft.com> wrote in message
news...Create form similar to MS Access 2000 Help
Is it possible to create a form that works similar to the Help - Index form
in Access 2000?
My StreetTable consists of the following fields: Street_ID(autonumber),
I want to be able to type the beginning letters of the street and the List
continually reduces until I see the street I need in the StreetNames window.
I would then
click on that street and the Directions would appear in the third window
Since I'm dealing with approx. 5000 streets, scrolling really isn't an
option that I want to consider.
I found that a combo ...can't delete mailbox #2
I deleted a user account in AD but when I go to Exchange system manager I
can't delete the mailbox. What is the deal?
Wait until AD replicates then you'll be able to purge the mailboxes with the
"Brandon Baker" <firstname.lastname@example.org> wrote in message
>I deleted a user account in AD but when I go to Exchange system manager I
>can't delete the mailbox. What is the deal?
Right click on Mailboxes in ESM and select Run Cleanup Agent.
John Oliver, Jr
MCSE, MCT, CCNA
Exchange M...Product list in CRM v.1.2
i have another question concerning the product list, can i attach an excle
sheet that contains my products instead of loging each product one by one as
i have over 25,000 products to log?
I'm afraid not. This is a major pain point for a lot of people and I do not
kno of any 3rd party add-ons that have addressed it either.
MVP - Microsoft CRM
"marwa" <email@example.com> wrote in message
i have another question concerning the product list, can ...HELP: Excel userform version control issue
I have an excel userform that is posted on my companys intranet. The issue I
am having is, users are saving this form to their hard drive and then using
it(Instead of launching it everytime from intranet), SO basically when I
have a new version of form on intranet they still use the old version as they
have a habbit of saving it on their hard drive.
Is there a way to resove this? something like they would see a popup message
saying that "This is an older version that you are using, Please launch the
form from Intranet for newer version".
Thanks in advan...Outlook attachment problems
Our oversea office sender using Outlook Sending message (HTML) insert a
picture sending message to my office, when I have received the attachment
auto duplicate one set in the message.
I have asked the sender try remove the picture and FORWARD to my e-mail,
but the attachment sill in the message and auto duplicate one set
Out overseas office using MS SBS , user setup WG mode for outlook
I am not sure which part problems or virus effect. Please advice how to
solve out the problems ASAP.
...OS version 10.2
In a previous post, I was told that Office 98 for MAC will not work on OS
10.2 and was directed toward getting Office 2004. In the system requirements
for 2004, it says that it is for users who have 10.2.8 or later. Is OS 10.2
upgradable to 10.2.8 or do I need to go with Office X or 2001 for OS 10.2?
Verdone Landscape Architects, Inc.
Heath Kuszak <firstname.lastname@example.org> wrote:
> In a previous post, I was told that Office 98 for MAC will not work on OS
> 10.2 and was directed toward getting Office 2004. In the system requirements
> for 2004, ...Matrix #2
I need to create a chart which is a matrix of four 'boxes' (a bit like the
BCG 'Cash cow, star, etc matrix if you know it). But am having real trouble.
What I need is this (and I'm going for the simplest method here - I ignored
the four 'boxes' and just tried to get the data as I want on the chart):
Project Name Value(1-10) Difficulty(1-10)
Proj1 5 8
Proj2 8 10
Proj3 1 8
Proj4 3 ...When will CRM 2.0 be released?
I was wondering if anyone has a firm(ish) idea when
version 2 will be released. I've heard 2005, but that is
a little vague.
My company has identified a few gaps that should be
resolved with the 2005 expected enhancements. If the
release is put off until this time next year, we will go
ahead and correct now. However, we would like to hold off
wasting time\money is Microsoft will deliver within the
1st two quarters of 2005.
The latest word is that CRM 2005 should be release sometime in calendar Q2 of
MVP - Microsoft CRM
---------------------------...Spinning Beach Ball
I seem to notice a correlation between seeing the spinning beach ball more often after launching MS Word for OSX. I removed the PDFMaker.Lib and this improved the performance a great deal, but still noticing the SBB more often after launching Word.
Anyone know about this?
Many Word issues are related to corrupt Word Settings or Normal Template.
You could try removing the Word Settings file, then testing. The Normal
Template could be renamed, then test. Be sure Word is closed before removing
or changing any files. You could also consider running the Remove Office
utility and reinstalling Offi...Help with Inbox repair tool please
I have a problem with my outlook 2000 and have been advised to use the inbox
I have opened the inbox repair tool, and I am asked to enter the folder name
or to browse and enter the location of the folder, I need to enter the
delete items folder but do not know where to find it.
Any help appreciated.
The Inbox Repair Tool works against Personal Folders Files (.PST files), not
against individual folders within the .PST file. If you don't know where
your .PST file is located, you can find it this way:
In Outlook, make sure the Folder List is visible (View | Folder...Help with
I am currently in the process of migrating exchange 2000 to exchange 2003 on
I have transfered the RUS role, offline address book role and replicated the
public folders ect. and now am beginning to move maiboxes. I noticed 3 very
repetive errors in the application event log however. I was wondering if
someone could tell me whether these messages are somthing I should be
concerned with. See them below. So far I have no user complaints about
Event ID: 9320
Description OALGen could not generate full details for some en...Help; how do i change the waiting circle (in IE tab) to anything e
I am making a website and i have a lot of wait time for my server-side pages
to do their work.
The waiting circle icon gives me a headache so I would like to change that
to something else please.
I remember IE6 had a great Microsoft Flag logo that would wave while a page
would load. Could I get IE8 to use this logo?
Sorry Trozza, you can't.
"Trozza Mited" <Trozza Mited@discussions.microsoft.com> wrote in message
> I am making a website and i have a lot of wait time for my server-side
> p...Excel #2
College text asks students how to save a file with a preview? I assume a print preview? Any suggestions?
On the Summary tab, check 'Save preview picture.
Tech Coor wrote:
> College text asks students how to save a file with a preview? I assume a print preview? Any suggestions?
Excel FAQ, Tips & Book List
...retrieving data from Great Plains via eConnect
I've been working with eConnect for the last two weeks and have had success
with importing a variety of transactions into Great Plains.
However, I'd like to query Great Plains on demand and have data returned to
me. For example, given a certain field value (like customer name = "Smith"),
I'd like to have all customer records returned that match that specified
value. Is there any way to do this easily with eConnect?
I'm not so interested in the Transaction Requester Service because that
seems to be focused more on automatically returning records that have...HOW USE 2 LANGUAGES IN AX. ???????????
I have problem and I need Help:
1. Axapta using English Language in all system
2. I need write something in Russian Language. When I use Russian Keyboard
and I wriet
somethings in Axapta fields is ok, but after this Russian words was change
and I see only symbol
likely this ??????? (query)
3. In MS SQL database in the fields I see words likely this symbol ???????
Please send my all information how I can write something in different
Languages in this same
Axapta - I need write simultaneously in 2 Languages.
Please send answer on ma email: email@example.com
Thank...Please help with New Database Query
Newbie to New Database Query - Can you change a spreadsheet to a table if so
how? I have a lot of spreadsheets that I would like to work with in New
Database Query. Can this be done. Any help will be greatly appreciated.
In general, if you select a range and give it a name....MS Query will
recognize it as a data source:
Example for data in Cells A1:Z500, with column headings (EmpID, FName,
In the Names box (just above the Col_A heading) type rngMyData1
Next, save your workbook.
Then...Data>Import External Data>New Database Query
When y...CDialog::DoModal() (2)
Few days ago I have asked the same question but didn't get any answers.
:( This is my problem:
I have written plugin for one app and it crashes here:
if (m_nFlags & WF_CONTINUEMODAL)
// enter modal loop
DWORD dwFlags = MLF_SHOWONIDLE;
if (GetStyle() & DS_NOIDLEMSG)
dwFlags |= MLF_NOIDLEMSG;
//It crashes on the line below
VERIFY(RunModalLoop(dwFlags) == m_nModalResult);
I belive that possible cause was that I didn't initialized MFC in any
way. I have noticed this in my other pro...Help With Problem: Nested IF Function, Office2K v Office2003
I'm looking for some help with a nested IF worksheet function. Shown
below is a formula that I'm using in a model.
If short, what I'm trying to do is scan the data in two columns and for
any cells which meet the TRUE case in both columns, then sum the third
numbers for all cases returning TRUE-TRUE. If either cell returns a
FALSE, then enter 0.
I created the original formulas and model in Office2000 and have used
the model for more tha...Outlook 2003 Cannot Send #2
i am using outlook 2003 and windows XP and can receive but not send e-mail.
i can send occasionally but only about 1 out of 50 or so attempts, so i am
assuming that all my settings are correct as i can send sometimes. i have
just upgraded to outlook 2003 and was using outlook 2002. i have verified
that my account settings are correct. i have no firewall. can anybody offer
Does the email you are trying to send bounce back as undeliverable? If so,
what error message goes with it? I am fighting something similar with
Outlook97, and am looking for ideas of what to ...MS Query help required
I have a spreadsheet on my notebook which I use for DBA services at a
particular client. It connects to database server via an existing ODBC
database connection extracting data from system tables. I would like to be
able use this spreadsheet at other clients, WITHOUT having to create a new
Is there any way that this can be accomplished?
The ideal scenario would be that the logon credentials and server address
reside on one sheet and upon arrival at another client, one merely changes
this information and then queries the database.
Any help would be appreciated.
Regards -...Information Store Crash #2
The Information Store on our Exchange 2000 server crashed. The following
errors were in the event log, but I cannot tell if they are a cause or a
symptom of the crash. If anyone has any insight, that would be great. . . a
reboot seemed to correct the issue and it has not happened again.
Event Type: Error
Event Source: EXCDO
Event Category: General
Event ID: 8217
Time: 1:55:25 PM
The processing of the recurring appointment with the subject "Tom is gone
after 2 pm (class)" in mailbox: UserA failed with error code 0x80040...