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...Category color changes when changing values.
When I copy a chart I get two identical ones. When I change the values of one
of the charts and sort the values, Excel changes the colors of the categories
to a preset order, so that the color of the biggest customer in chart 1 is
not the same as this same customer (let's say now on the third place) in
Is there a way to prevent this?
...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
...Rule for meeting appointments / invitations?
Here's a new one on me. I'm in yet another contract, this time it's my
first at a managerial level. So, moving on up.
The new twist here is that I'm receiving all the meeting invitations sent to
my boss, a DG. And they're turning out to be quite a few. Since they're
just coming to me and I don't need to action them, wanted to set up a rule
so that they'd be diverted into a specific folder. Also, would like my own
meeting requests to have a rule of their own to go into yet another folder.
But, couldn't figure out how to do this via the usual rule ...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
No - there are no rules either. This is really odd! I
still seel in my folder list under my name all my folders
then another title that says Outlook Today with all my
folders under it too.
...Rule not working
Background: I have a user with two email addresses. His
primary address is "firstname.lastname@example.org" and he has a second
address called "email@example.com". We are running SBS2003
with Exchange and the user is using Office 11.
Goal: He wants all mail that is sent to the
firstname.lastname@example.org address to be forwarded to another user in
the same domain.
Problem: Sounds easy enough, right? When the Exchange
server receives a piece of mail to email@example.com, it
renames the recipient to firstname.lastname@example.org thus causing our
rule not run. Obviously we can't forward all mail to the
o...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" <email@example.com> 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" <firstname.lastname@example.org> wrote in message
i have another question concerning the product list, can ...Multiple colors transparent in picture-HOW?
I am trying to make multiple areas of a picture partially transparent, but am
unable to in Publisher. What programs would allow me to make this change?
If it is a bitmap, i.e. jpg, bmp and others, you need to use a photo editing
program. If it is a vector (.wmf) you can ungroup the image, select the area you
want partially transparent, right-click, click format object.
This link will take you to Paint.NET, it is a pretty good free program.
Mary Sauer MSFT MVP
...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 <email@example.com> 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...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
...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: firstname.lastname@example.org
I am the author of a document and am making revisions to it. I want to
chnage the redline color to denote new edits from the 1st version. Can
anyone guide me through this process? I am sure it is easy but I cannot
figure it out. THanks Peter
On Wed, 10 Feb 2010 07:08:06 -0800, Peter SSI <Peter
>I am the author of a document and am making revisions to it. I want to
>chnage the redline color to denote new edits from the 1st version. Can
>anyone guide me through this process? I am sure it is easy but I cannot
>figure i...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...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 ...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...2 Axis Pivot Chart
Is it possible to create a 2 axis (a combination of line & bar) chart from a
Sure is, did you try?
Right click a series that you want on the secondary axis, choose Format
Series, and on the Axis tab (Excel 2003 and earlier) or the Series
Options tab (2007) select the Secondary Axis option.
To change the chart type, right click on the series, choose (Change)
Chart Type, and select the type you want.
Of course, the pivot chart is likely to lose this formatting when it is
refreshed, Which even Microsoft admits is a problem. They suggest
recording a macro next time you f...macro #2
I'm new at this so this might seem elementary but if you don't know you ask
those that do.
I've created a macro that is suppose to clear the input data on a worksheet
when a command button is clicked. However when the msgbox appears asking
them if they wish to continue and they click "yes" nothing happens.I've
included the code that I've written. Any help would be appreciated.
Private Sub cmdclear_Click()
MsgBox "Caution: You are about to delete the information on this worksheet"
& vbNewLine & vbNewLine & "Do you wish to continue?"...publisher 2003 will not insert MS clipart #2
Error message - Publisher cannot insert this picture into the publication.
The appropriate graphic converter is not available. For information on
running Setup to install converters, press F1.
"Pub 2003 will not insert MS cliipart" wrote:
> Error message - Publisher cannot insert this picture into the publication.
> The appropriate graphic converter is not available. For information on
> running Setup to install converters, press F1.
p.s. to this message, F1 provides no information and I already cleared cache
in IE tools. Did not work. Clipart will not insert.
&qu...Conditional Formatting based on deadlines #2
Excellent! Thanks! My brain gets confused between what you can use i
formulas and what can be used in VBA.
Alex Delamain Wrote:
> Under conditional formatting set condition 1
> Formula is =+$E2<=NOW()+7
> Then apply your forma
madbloke's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=27448
NOW() has a date and time component
TODAY() has only a date component
Ok, incorpo...How 2 sort an autosum total list after adding items 2 autosum item
Am using detail dollar amount list to insert new transactions in the middle
of a the detail list, and they in turn get included in the 'autosum' total
calc which is located in another item total summary list in the same workbook.
If we try to sort the autosum total summary list, the autosum totals seem to
loose their connection with the detail autosum calc list.
Is there anyway to keep this connection, ie be able to add items into the
detail autosum calc lists, and then sort the autosum summary totals ?
Thanks again for your help.