Conditional Formatting #2
Is there an easy way to format the color of a bar based on it's value? Or is
it only through macros that this can be achieved?
Conditional charts can be created by using multiple series.
See here for more information.
> Is there an easy way to format the color of a bar based on it's value? Or is
> it only through macros that this can be achieved?
Andy Pope, Microsoft MVP - Excel
Thanks a lot...it works great!
"Andy Pope&q...how do i get 2 words in one cell on top of eachother?
Like in word when you hit enter in a chart it expands the cell and allows you
to have more than 1 word on top of eachother?
ALT then enter at the end of the first word.
If my comments have helped please hit Yes.
> Like in word when you hit enter in a chart it expands the cell and allows you
> to have more than 1 word on top of eachother?
...How will this work: Changing bill payer from MSN Bill Pay to my bank
My one year of MSN Bill Pay premium service, included in M03 dlx is
close to expiring.
So I am planning to use the service from my bank, (their bill payment
service is fully integrated with Money ... they say). I'd like to know
how all the payees I've setup in M03 will function if I switch Bill Pay
providers?, or if anyone has any experience switching like this?
For example, several payee's I've setup in M03 cannot be deleted, nor
can their name be edited. I'm sure there's a reason for this, although
I don't know exactly what it is, (my guess is there'...CRM and Great Plains Overlap?
This post is for someone that knows both GP and CRM.
I am working a prospect that will be getting GP (from someone else) and they
have seen me demo CRM.
CRM looks real good except that they are saying GP accounting has pretty
good opportunity management built into.
We are trying to figure where and how much CRM and GP overlap for both sales
and service as compared to just integrating - product catalog comes from GP
into CRM. Orders and invoice are driven out of GP when quote is accepted in
Since we don't know GP we are trying to get a handle on it.
The prospect is wondering how m...Account payment receipt #2
can someone help me with this
i need to print the trans number being paid on the payment receipt full page
along with last payment and payment type
...use match from the bottom to the top. #2
the match function gives the index from the top
is it possible to use match from the bottom to the top?
ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)"
You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're
> the match function gives the index from the top
> is it possible to use match from the bottom to the top?
> ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)"
But what if some cells in the range are empty? Try
"Sean Timmons" wrote:
> You c...Converting 4 page doc to 2 pages
I created a program in Publisher and sent to our printer. They called back
and said the Xerox is not recognizing the format. Publisher has this
formatted in 8.5 x 5.5.
How do I put 2 pages onto one page so it will print?
If you have setup this as a booklet, open a new instance of Publisher, setup the
page as landscape, insert an additional page. Open your program, copy each
page/paste to the new publication, two per page.
"Pam" <Pam@discussions.microsoft.com> wrote in message
news:9AD06459-5EC4-4F84-A881-380BF1F2652...Backing Up Outlook #4
I want to back up my Outlook files to a CD. I can't find
the folder (Personal Folders?) where they are stored
as .pst files. (I tried the Outlook Back Up function to
add it to the CD, but it doesn't appear on my CD
compilation list afterward). Can you help. Thank you.
do a searh for *.pst you will find them
>I want to back up my Outlook files to a CD. I can't
>the folder (Personal Folders?) where they are stored
>as .pst files. (I tried the Outlook Back Up function to
>add it to the CD, but it doesn't appear on m...CELL/NUMBER FORMAT #2
EXCEL. When entering a whole number into a cell EXCEl is dividing
that number by 10 immediatly after entry. If I place a decimal point
after the number this does not happen. If I enter a number less than 1
the number is entered normally. It appears that EXCEL needs a decimal
point to enter the number correctly. I have used EXCEL for many years
(current version from 2004) and this has never hapenned. Any Ideas out
Sounds like Fixed Decimal is set.
Go to Tools>Options>Edit, and if the Fixed Decimal box is checked, uncheck
(remove nothere from the email ...Publisher Question #2
How do I save a group of images/pictures as one image/picture so I can use it
in other software programs, such as Quickbooks?
Nikki <Nikki@discussions.microsoft.com> was very recently heard to
> How do I save a group of images/pictures as one image/picture so I
> can use it in other software programs, such as Quickbooks?
Select them, Group them, right-click > Save as Picture
Ed Bennett - MVP Microsoft Publisher
This is what I have done in the past but the version of Publisher I have now
(2000) does not show "Save as Picture".
"Ed Bennett"...Using lookup to copy values from a master to client worksheet
If I have a columns of data in a spreadsheet with, say, a name in the fist
column, is it possible to create 'client' spreadsheets which contain only
rows with a particular name ? So the 'Master' sheet has many rows for each
name but the 'client' sheet has only entries for a particular name ?
Any help or pointers much appreciated.
I would use 'Data - filter - Advanced Filter' for this
"Malcolm Hind" <m.hindNOSPAM@btinternet.com> schrieb im Newsbeitrag
news:Xns9575A1D6B766MalHind@67.98.68....Will not Excel anymore...Please help!!
I can't get my xbox to load any games anymore... Do I need to get it
No, ditch it, buy a copy of Excel and write your own in VBA.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"Marty James" <firstname.lastname@example.org> wrote in message
news:BD2D7E64.6673%m...Define whether to use list 1 or 2
I do have three Insert > Name > Define > lists created on one
How to have either one of the 1st two list activated on a cell when the
neighboring cell a value is choosen from the 3rd list list?
If Yes > List A
If No > List B
Is this used with Data|Validation?
If yes, Debra Dalgleish shows how to create dependent lists:
AA Arens wrote:
> I do have three Insert > Name > Define > lists created on one
> How to have eithe...Outgoing mail server #2
I'm getting an 'error' message,rather i'm being timed
out;the outgoing mail server is not responding. What's the
...CRM 3.0 Outlook Client / Search for Account Name
Is there any way to customize the view in Outlook to display the CRM account
Is there any way to search for the CRM Account name from Outlook? This
feature appears to be removed from the Outlook client when I upgraded to 3.0.
Usherwood Office Technology
...Clip Art problems #2
So I download some clip art from MS and it lands on my desktop. I
can't access it via Word though. I drug it to the Office folder on my
hard drive but it still won't open.
What have I done wrong and what do i need to do to get it right?
Always a good idea to mention what version of Office, but have you tried
just double-clicking the icon on your desktop? The filename should have a
<email@example.com> wrote in message
> So I down...3D Scatter Chart #2
How can I plot three columns of numericla data as a 3D scatter chart (x,y,z
axes) using excel? Is this possible?
No matter, found one myself from a previous post (courtesy of Andy Pope):
> How can I plot three columns of numericla data as a 3D scatter chart (x,y,z
> axes) using excel? Is this possible?
...Using Outlook 2003 As Default Mail Client #2
After installing Outlook 2003 on top of Outlook 2002 on an WXP Home machine,
I can't get Outlook to work as the default mail client. It does work properly
if you type mailto: in the run box, but it doesn't work from IE or any other
applications. I have set it as the default mail client. I have changed it to
Outlook Express and back again. I have set it as default when Outlook opens
and asks to be made the default. The error message is: a small window opens
with a yellow caution sign saying, "Micosoft Outlook "Not Implemented". Any
help would be appreciated.
Thank...Default Email Client #4
How do I make Outlook my default email client?
Internet Options/Programs tab
Stop using whatever you were using
<firstname.lastname@example.org> wrote in message
> How do I make Outlook my default email client?
...Enter data on to a speadsheet using a VBA form #2
can any help need to be able to enter data onto a worksheet using a VB form.
...what is this CRM?
Help. I've got it but I don't know what it is. Is it a disease?
...Online folder view in Outlook
>From the bookm "Microsoft Outlook Programming: Jumpstart for
Administrators, Power Users, and Developers" by Sue Mosher I have found
out that custom html-views of folder content can be created using
value="\\Private folders\My Folder">
<param name="DeferUpdate&qu...Charting dates #2
I am creating a graph in Excel 2007 where there are multiple dates on the X
axis. By default Excel groups duplicte dates togeather on the axis. You can
have them seperate as individual data points by formating the axis and
selecting "Text Axis" in Axis options.
Is there a way to this in Excel 2003?
Chart menu > Chart Options > Axes tab, change from Time Scale (or Automatic)
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"Terry" <email@example.com> wrote in m...Delete All Jobs Except 2?
Using something that would work in 2005 and 2008, I am trying to
figure out how to delete all jobs except for two. Some runaway scripts
have added 40+ crazy-named jobs, and I need to get rid of them all,
but keep just two. Can anyone point me to the right queries to capture
all jobs into a table var or something better?
Select * FROM msdb.dbo.sysjobs ~ List all jobs including Job_id
In a cursor or loop
Delete msdb.dbo.sysjobs where Job_Id =
> Using something that would work in 2...Mark cell when changed #2
I have an Excel sheet which is filled with formulas linked to a data
warehouse. To be able to easily detect changes in the the past I was
wondering if you can format a cell so that it (for example) turns red
as soon as the value in it changes due to an update of the sheet.
Hope that someone can advice me.
Thanx very much in advance.