Cell text color change
I'm trying to get the text color in a cell to change (to red) if the formula
in that cell produces a value above a certain ammount...
Could this be done?
Look at Format>Conditional Formatting
(remove nothere from the email address if mailing direct)
"Steffen" <Steffen@discussions.microsoft.com> wrote in message
> I'm trying to get the text color in a cell to change (to red) if the
> in that cell produces a value above a certain ammount...
> Could this be done?
...Out of office assitant
My wife is starting a new business venture from home and is used to many
features in Outlook from her old company. I've learned that some feature are
not available because our home computer is not set up using Microsoft
Exchange Server, but an Internet mail service. Is there any way around
this?? Can I set up a single home computer to utilize MS Exchange Server?
"Dave in Franklin, TN" <DaveinFranklinTN@discussions.microsoft.com> wrote in
> My wife is starting a new business venture from home and ...Using Dates with the IF function
Is it possible to format a cell using a formula such as the following:
Column L uses an X to signify that a crime report due date has an expiration
of 14 days. The date of the crime is listed in column B. How do you format
Column H to signify if the date entered in Column H has expired (greater than
14 days past the date in Column B)? I would like the cells in Column H to
change color if the date entered is 14 days past the date of the crime in
I am using Excel 2003
Use conditional formatting (in the Format menu). Something like:
...Best replicas and the Best Service and Guarnatee to Back up Our Watches
Best replicas and the Best Service and Guarnatee to Back up Our Watches
REPLICA WATCHES: http://www.precisionreplicas.com
We offer you a World of Luxury at very affordable prices and you can rest
easy about your satisfaction of quality and service.
Now, with just a few simple steps, you can own something that will make you
feel and look great! You can go to that business meeting, sales conference,
or cocktail party wearing a beautiful watch and be sure to catch people's
attention. The way you act, dress and present yourself will always be looked
upon by others. By choosing from our selec...ms excel spreadsheet
After creating an Excel (Excel 2003) spreedsheet, how can i get the user to
fill in the necessary/required cells (and telling the user to fill it in is
not good enough)? Or is there a way to have Excel check to make sure these
cells are filled in upon saving it?
You can create a before close and/or before save macro that checks the cells
and refuses if not filled.
Microsoft MVP Excel
"Matt K." <MattK@discussions.microsoft.com> wrote in message
news:33EFF746-F964-4A36-8FC7-ED4CD3C54119@microsoft.com....'problem starting the Office Assistant'
I know this is slightly off-topic but...
I'm using Excel from Office 2000 and am getting an error on startup
which I'd really like to get rid of:
- There was a problem starting the Office Assistant. Would you like to
try installing it?
I did try to re-install it but it didn't help.
Any tips on how to get rid of this would be welcome!
>From Excel, along the menu at top, click Help and de-select "Show the
Office Assistant". I'm biting my tongue, trying to resist the urge to
editorialize about THAT particular piece of code.
On 21 Nov 2005 18:...RE: Prove this internet pack that came from the MS Corp.
Content-Type: multipart/related; boundary="pckvxszspjef";
Content-Type: multipart/alternative; boundary="tfednwbduguwdhf"
this is the latest version of security update, the
"February 2004, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now ...Delete date range of emails in mailbox using ESM?
In Exchange 5.5 we could click on a mailbox and select a date range and set
it to delete those emails, I can' find a way in ESM for Exchange 2003. I
have tried deleting a few 1000 emails from a mailbox that stores audit emails
using my Outlook and it takes forever, is there a feature from ESM that can
still do this?
You could setup a mailbox manager rule (via recipient policy section).
Another option would be to use Exmege.
Set a date range and then tell it to archive rather than just export.
"SW" <SW@discussions.microsoft.com> wrote in message
Can anyone help?
I can create a template, no problem. I can reply to emails, no problem. What
I can not do and for the life of me, I'm not sure Outlook does either, is
reply to an email using a template.
It seems so simple, Reply, Reply To All, Reply Using Template ...
In Outlook 2003, one had to create a custom rule. In Outlook 2007, the
feature has been removed.
Any ideas on how I can reply to an email with a specific template?
I use templates in Outlook 2007.
Check here it may be helpful:
/ Andr...Outlook/Outlook Express Address Book
On the same computer, I use Outlook and the spouse uses
Outlook Express. The address books in each of the
programs were separate, all of a sudden my address book
in Outlook disappeared and is using the outlook express
AB for both programs. Can anybody tell me what happened
and how to separate the AB's again and where did MY AB
That is not possible. OE can use Outlook's address book, but not the
Provide more accurate detail including your versions and what produced this
"Bob" <firstname.lastname@example.org...Best Web Service Approach
I'm a bit of a newbie to web services, and would appreciate some
thoughts as to the best approach for making a web service available to
various, possibly non-microsoft, clients.
I need to accept "orders" which are in an XML format defined by an XML
schema (XSD) set by an external standards body.
I've already got a set of class definitions which allow me to
deserialize a valid XML order into an Order object (although I'm not
absolutely certain that the class definitions exactly match the Schema
in terms of "IsNullable=False" decorations etc).
So my question is...Full Text Indexing and Permissions
I working on a CRM 3.0 deployment that is built on Sql Server 2000
Windows 2003 server.
I want to create a report that looks for the frequency that
products are mentioned in emails and this requires Full Text Indexing
to be able to tune the search criteria.
Now, to my knowledge, in SQL Server 2000 you can only index tables
views and it is too far into the project to goto SQL 2005. Am I right
or is it possible in 2000?
For now, I've added Full Text Indexing to the ActivityPointerBase
table, including Description and Subject.
My problem now is how to give permission to...text appears in gray only
When I print out excel worksheets on my epson 440 color
printer all text and grids appear in grey only. Any
"email@example.com" <firstname.lastname@example.org> wrote in
> When I print out excel worksheets on my epson 440 color
> printer all text and grids appear in grey only. Any
File > Page Setup > Sheet tab
Do you have "Print: Black and White" checked?
...Spammer using fictitious account on own domain
This is a security issue, so I don't know if I'm posting in the right group,
but here goes anyway.
I've started receiving spam from an address in my domain, which does not
The header of the spam uses a fictitious user account. For Example;
Subject: RE:what is that? Spammer [email@example.com]
To: Genuine User
Also Exchange System Administrator is sending me the following message. I've
changed some of the details for security reasons.
-------------------------...A 2 line text showing up in the Cell in Excel prints in 1 line
When I type in text in a Cell in Excel, and wrap it, it fits in 2 lines. When
I print it, it prints in one line, leaving the other line as blank space. I
could not figure out what is the problem. This also happens for 3 or more
lines....when it prints in one line lesser than what it shows up in the Cell
on the computer
It wraps, right, it wraps over the viewport, in this case, the screen,
now, the printer is another viewport, a hard-wrap and a soft-wrap are not
the same and the printer uses different stdout, so, as the other fella
said, use alt-Enter to put a hard-wrap, or, an act...$3.50 best invest....
The First randomizer on the net with MONEY BACK GUARANTEE!
Best of all .... we will Refund your money back to you if your turn of to be
paid do not come in the 29 days of your signup(We are sure ..we DO NOT have
to refund you , because you will love this program after you signup.YOU CAN
GET PAID ON THE NEXT DAY OF YOUR SIGN UP!!!)
...Need some advice on using rpc over https in the office
I need your advice on these. Is it better to use rpc over https for outlook
users inside office than using TCP/IP? Any security concern since we need to
allow internal users to access the DMZ server directly - exchange front end
sever? If we configure the outlook users to use rpc over https inside the
office, what's connection status shown as TCP/IP or https?
Depends on your Outlook config, if you have set your profile to use
TCP\IP on fast connections (LAN) it will use TCP\IP, otherwise it will
default to RPC\HTTP such as when at home. Some people create two
p...Excel's Best Kept Secret
I use this function in 75% of the applications that I develop for my
clients around the world yet so few users know about SUMPRODUCT
Click below to download a free spreadsheet on the subject
...Payroll Manual Check Inquiry
We use manual checks to make adjustments to taxable wages. When we go to
Check Inquiry, we can see the manual check but when we click on Transactions,
this window is blank. How can we go back to see the original transaction to
see the amounts that were entered?
Do you get the same result when you go to Inquiry > Payroll > Transaction
History for the employee(s) in question? If so, have you posted all your
manual check batches?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://d...suggestion or recommendation for a good Excel reference book
Can any one recommend a good reference book for Excel formulas, functions
and their use.
or a list of available functions and how they are meant to be used.
Thought it might help eliminate some of those simpler questions.
Just ran across the following using a web search. The site looks to have a
number of free Excel worksheet function training videos you may find ...Office word 2007 cannot open a document on the Desktop
any one can give a help
in the last few weeks I saw a error within Office Word 2007, which it can't
open a document on the desktop and following message comes up (There was a
problem sending the command to the program.).
I applied the file extention from Control Panel and it still exists,
sometimes I had had to click on the document right click and open it through
the choice (Open).
Many thanks indeed.
Run Office Setup from the Control Panel and choose the REPAIR option.
Terry Farrell - MSWord MVP
"Elsh...Temporary fix for Money Sign-in problem using Passport
I recently found a fix for the sign-in problem that people are having
logging into Money using Passport. I'm using Money 2004 Deluxe on
Windows98 SE. I found a post (after a rediculous amount of searching
newsgroups) by someone saying to try starting up Money Express first.
Here's what I did:
Found the Money Express program on my harddisk at "C:\Program
Double-clicked the program to start it, found the icon in my taskbar
at the far right (since nothing showed on the desktop after I started
up the program), double-clicked the icon...how do I amend the leading of the body text...
I am doing a course assignment in Publisher 2000 and need to find out what this text means:
"Amend the leading of the Body text so that the columns are balanced to within 10mm of the bottom of each page."
"leading is consistent"
Hope you can answer. Thanks for your help.
Because this is a course assignment, I'm not going to give you all of the
answer *but* I will point you in the right direction:
Read the Help file. Search the Index for Leading.
(Sorry, she won't learn if we hand her the answers - life isn't that simple.
...Text size on check boxes
Is there any way to increase the text size on check boxes? Thanks in
I forgot to mention, Increasing the font on group boxes will be nice
...Best way to handle collection of similar calculations?
I frequently encounter situations where I want to perform a set of
similar calculations on different data. If it's a table, like new a
series of readings over time, I can set up a row for each entry and
copy the formulas down each time I add a new row.
But what if I want to replicate the entire sheet such as starting a
new series of readings? Is there some way to set up some kind of
"template" sheet that will be used for multiple derivative sheets?
Say I am keeping track of mileage and service for a car. I have a
sheet set up with rows and columns where I can enter gas purchase...