Conditional formatting Icons
I have values for two months - Current and Previous. If current month's
value is closer to zero than previous month's value then i want to show a
green arrow. If current month's value is away from zero than previous
month's value then i want to show a red arrow. Though these values are
positive and negative both, i need to apply conditional formatting on
1.2% 2.4% Red Arrow
1.2% -2.4% Red Arrow
-1.2% 2.4% Red Arrow
-1.2% ...Try this corrective update for Windows
Content-Type: multipart/related; boundary="dxslqsnvlsnz";
Content-Type: multipart/alternative; boundary="mcsszxsuxwtdg"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install ...help with a scatter graph of conditioned values
I'm a big newbie in matter of charting and vba...I hope somenone can help
me....here is my problem
I need to plot a XY scatter graph.
X and Y data values are mutually dependents one each other and they change
under an extra condition that I want to represent qith a macro control.
Hmmmm...let's try to give you an example:
first of all I need to define EXTRA CONDITIONS as follows
My goal is to have a control in cell C1 that traduces "if 'name'=A then
'S'=1, if &...Trying
Trying the outlook news.
Also trying the news outlook
"user00" <firstname.lastname@example.org> wrote in message
> Trying the outlook news.
...Error when trying to import data that was exported on another computer on networ
A file error has occurred in Comma Separated Values
(Windows) translator while initializing a translator to
build a field map.
The file \\Laptop\claptop\documents and settings\All....
The disk is locked, the file is a read-only, in use by
another program, or because you don't have permission to
use a network path.
...Error when trying to copy worksheet within workbook
I keep receiving a prompt when trying to copy a worksheet within a
workbook....goes along the lines of
A formula or sheet you want to move or copy contains the name "...." which
already exists on the destination worksheet. Do you want to use this version
of the name?
Select Yes and it goes through a list of nameswhich could be upto 50 or so.
DO you know what is meant by a named cell? Cell A1 can be given a name such
as Rate. Now suppose a cell on Sheet1 is named Rate and a cell on Sheet2 is
named Rate. Want happens when you copy from Sheet1 to Sheet2? Excel ...Conditional Currency Formatting
I would like the currency format of my cells to change depending on th
value of a combox or cell. I know this can't be done using conditiona
I have tried using the .NumberFormat code in VBA but I get th
Run-time Error '1004' Unable to set the NumberFormat property of th
I am using Excel 97.
Ideally, I'd like to solve this without using code!
Message posted from http://www.ExcelForum.com
Without knowing more, I can't provide a detailed=20
solution. But this example may help. If A1 is greater=20
than 100, for...System restore size doesn't "Stay put."
I set my System Restore size to 1 percent of my hard drive.
But when I go back and check it's size, it's back to Windows default
of 12 %.
This behavior adds a lot of time to my defrag program because it's
moving all those unneeded system restore points.
Is this a bug or can it be fixed?
Do you actually need to have system restore set on your system? I
haven't used it AT ALL since I bought my dad bought me my own
first PC and Laptop in 2001 (I was 10) with Windows XP
pre-installed! It is not what MVPs make out to be because it
doesn't actually...How do I restore margins/page layout on Word 2003?
I had opened a Word document from an email attachment, and its margins were
wide (from 0 on the left to 8 on the right). My normal Word 2003 default is 0
to 6. Now every time I open a new document in Word it has the wide margins.
How do I restore them?
Simply opening a document wouldn't change the default margins in Word. Maybe
the view has changed? Verify that documents are displaying in Print Layout
view (look at the View menu).
If you find that the actual margins has changed, change them in File | Page
Setup and then click the Default button. If/when you are prompted to...Try Catch Finally in MFC
Iam using latest MFC Version, i believe 7.0. I could only find TRY CATCH
block in MFC.
How can i implement try -catch- finally in MFC?
One thought i have is to throw an exception while iam in try block when i
want to return.
Is this a good idea?
//When i want to return due to improperly formatted parameter to the
function, i will throw a custom exception.
> Iam using latest MFC Version, i believe 7.0. I could only find TRY
> CATCH block in MFC.
> How can i implement try -catch- finally in MFC?
> One thought i have...Exchange oma dataprovider gives error whenever try to access
Checked permissions and SSL on oma virtual site.
Whenever anyone tries to access the oma virtual site an error appears in
the error log and they are denied access.
An unknown error occurred while processing the current request:
Message: The remote server returned an error: (400) Bad Request.
Microsoft.Exchange.OMA.ExchangeDataProvider.ExchangeServices...How to restore close, minimize, maximize buttons
Either intentionally or otherwise, I don't remember, in my MFC forms
based application I lost everything in my program's title bar expect
for the title itself. Now I cannot figure out how to get them back. I
tried changing the form's properties with no luck and also cannot find
reference to these controls in the form's code.
Does anyone know where the code to show these buttons normally is in a
generated MFC project, or how I can re-add them?
Go to resource editor and right click on the dialog you want to restore
the properties. You can change style to include whatever you...Conditional Formatting #99
I have an issue with conditional formatting. I have the below formulas
assigned to their respective colors (Green, Yellow and Red) to highlight
quickly what categories I'm pulling numbers for are either; okay (green) and
need attention (red) ... Anyway, I'm looking at each category by site level
(I work for a Petroleum company) and each site numbers is a gas station in my
system ... however, for some reason my conditional formatting is
high-lighting (yellow) anything that I make as a "N/A" ... regardless if I
input it as "iserror" formula or manually ...trying to concatinate based on values matching in certain cells
I have the following info:
Sarah Schwartz A1 1163233
Anne Schwartz A2 1163233
Marcus Lehr A2 1582167
Eric Lehr A1 1582167
Matthew Weiss A2 2194223
Kari Weiss A1 2194223
Ryan Mc Cartney A1 2299079
Kelly Mc Cartney A2 2299079
Cornelius Brendan-Guiney A1 2301508
Roberta Guiney A2 2301508
Nancy Trojan A3 2302575
Kenneth Trojan A2 2302575
Debra Wittington A1 2302575
Shannon Kozlowski A2 2348145
Shannon Kozlowski A1 2348145
Jesse Zoller A1 2383021
Gary Zoller A3 2383021
Jeremy Zoller A2 2383021
I need to concatenate a string in colu...I've tried DSUM, SUMIF....
Can anyone please help me solve this frustrating problem!
I have 5 columns of info about my phone calls (the standard stuff: date,
start time, no called, duration, cost). Column E is the 'amount' column,
and I want to total all the amounts for calls which (in column 3) START with
a 7. In other words, I'm trying to find out how much was spent on all calls
to mobile phones (all leading zeros are removed).
Its easy to find totals for calls to particular numbers, but I can't figure
out how to total them all. The only criteria I can think of is that they do
all begin with...Trying to close year with a bad journal entry
I'm trying to close out the year for a company in GP 9. I get an error
that states: "account assigned to transaction is missing". So I find
the offending journal entry, but it has been voided. I cannot edit it
or delete so I can close out the year. Suggestions?
have you checked KB Article 855209 - Account assigned to a transaction is
missing? if not, go ahead and look it up in partnersource. this kb should
the reason why you are receiving this messahe is because of a record that
has an ACTINDX = 0. you may need to update it with ...How to restore the MS CRM 3.0 Database ??
I manage to create a backup database of MS CRM Database, but when I try to
restore it, I can't, I have the message : "the database is used with another
application..".. But the CRM application is closed.
Is there other backgroung using the database running ?
How can I do ?
Make sure the CRM services (all services beginning Microsoft CRM..) are
stopped on the CRM server; also stop the Microsoft CRM Exchange Email Router
service on your Exchange Server.
And you may also need to stop the CRMAppPool application pool in IIS Manager
(if running Windows 2003)
Hope this ...Trying to connect......!
For a while I had the Outlook 2003 HTTP/RPC setup working smoothly for my
users, but now I'm behaviour that I can't determine the cause. When a user
attempts to log into exchange via the HTTP/RPC connector in Outlook, they
are first asked to provide username and password with the usual popup box.
Everything seems ok, and "Trying to connect..." stage shows. Soon after, it
Disconnects. Then tries again. Then disconnects. Then tries again. This
has been repeatable from different locations, with different laptops at
different times. So, I believe this is a setting problem,...M04 closes when try to do investment report
While doing my taxes I tried to see a report for my investments over the years. I had set up investment account back in Money-98 and then upgraded to M-02 and M-04 small business. When I selected all dates or all to date option for the report Money just closed on me. If I select previous year or year to date it works fine
In microsoft.public.money, dmitat wrote:
>While doing my taxes
< I tried to see a report for my investments over
> the years. I had set up investment
>account back in Money-98 and then
>upgraded to M-02 and M-04 small
>business. When ...Error when we try to create a quick campaign
When we try to create a quick campaign we got immediately an error message:
Error: window.opener.document is null or not an object
Does anyone know why?
...Trying to see if...
this group is active
Very. Is there a problem?
<email@example.com> wrote in message news:firstname.lastname@example.org...
> this group is active
...Restore Deleted Item
What is the best way to restore a deleted item from a backup. The item was
deleted antecedently a couple weeks a go. I would like to pull all the info
that gets deleted from the backup of the day before deletion and input it
back into the database. What is the best way to go about doing this?
> What is the best way to restore a deleted item from a backup. The item was
> deleted antecedently a couple weeks a go. I would like to pull all the info
> that gets deleted from the backup of the day before deletion and input it
> back into the database. ...Try this internet pack from M$ Corporation
Content-Type: multipart/related; boundary="yaprdlxknw";
Content-Type: multipart/alternative; boundary="tzoyybjqnb"
this is the latest version of security update, the
"November 2002, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to maintain the security of your computer.
This update includes ...How to restore public folder permissions
Unfortunately one of our customers has changed top level security
permissions on a public folder. All user permissions have been changed. The
customer didnt document the permission structure to set them correctly again.
Question: Is there a way to restore the security permissions to a test
environment, we dont want to use the production environment for this? (so not
the public folders themself)
Possibly we need a spare server to restore to and then read the settings, i
imagine that wouldnt work correctly because there's no DC, do we need to set
up a temporary DC also?
Hope so...Error in trying to add new user (Deployment Wizard)
I have installed MS CRM 1.2 on my Win2K server with SQL2000 SP 3 and
..NET Framework 1.1. I didnt installed Exchange Server though.
When I went to the Deployment Manager > User Manager > Adventure Works
Cyle, I hit this error:
"Cannot open database required in login
'Adventure_Works_Cycle_METABASE'. Login failed (80004005)."
Is this has to do with some permissions that I should set in the SQL
Please help. Thank you.
CORCEL SYSTEMS SDN BHD, www.corcelsystems.com
We design and develop business-led database-driven web app...