Conditional Formatting Help
I would like to apply conditional formatting for my spreadsheet with the
Condition 1: If Column C Font is Bold then bold entire row and interior
shade entire row gray.
Condition 2: If Column B is Blank then shade entire row light yellow and
format entire row font italic.
Can't seem to figure out the formula for this. Any help is greatly
You havent mentioned the conditions for formatting these two columns..
Jacob (MVP - Excel)
> I would like to apply conditional formatting for my spreadsheet with...Excel Text Function
Hi anyone who can help me...
I have some info in a spreadsheet as follows:
A1 B1 C1
Centra Dublin Centra Belfast Centra London
If I want to get just Centra out into another cell I would
use =LEFT(A1:C1,6) and this works fine. But I want to
actually get out the area - Dublin, Belfast or London and
some other areas that might have more or less than 7
letters. Any ideas???
Thanks in advance
Ann (Dublin, Ireland)
will work if you have city names and centra..
"Ann&q...Stagger X-axis text
In 1-2-3 I could stagger the text in the X-axis. In Excel it seems
that I can only rotate the text to 90 degrees.
Is there a way to stagger and leave horizontal?
Specifically, I have all the provinces (or 10 of them) across the axis
and they take up room when spelt out (no abbreviations allowed). I
would rather the first, third, fifth ... etc. be higher and the
second, fourth etc. be lower to allow the chart to be narrower and
still read the text clearly.
>In 1-2-3 I could stagger the text in the X-axis. In Excel
I would...How do I get excel to accept (c) as text and not change to copyri.
How do I enter the text (c) in Excel without having it changed into the
Tools | Autocorrect | Select (c) | Delete | OK
"daffyd" <email@example.com> wrote in message
> How do I enter the text (c) in Excel without having it changed into the
> copyright symbol?
Go into the Tools Menu. Look for AutoCorrect. In the bottom half of the
AutoCorrect Tab, look at the list for Replace text as you type. Delete the
entry for (c).
"da...HELP!! Viewing email images
I have just recently switched to using Outlook rather than
Outlook Express as my email program.
I now find that any image attachments (.jpg, .bmp etc.) I
receive are not visible onscreen as they used to be in
I have to click on each attachment icon to view...
It's annoying, especially if I get a series of pics...I
have to manually ope each one...
Does anyone know how to set Outlook so that it shows me
these images onscreen???
...I'm missing all past years emails in my hotmail account
For some reason i logged in into my hotmail account and noticed that all my
past years are gone. I havent deleted anything. I'm missing emails from 2006
till 2009 all of them? Please help....what can i do?
If the Hotmail account is set as your primary store, could it be that you
have AutoArchive enabled?
Tools-> Options-> tab Other-> button AutoArchive...
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Re...links in emails
When I try to open a link included in an email nothing
This problem can be caused by several different things. Do you receive an error message when you click on a hyperlink, or does nothing happen at all? Can you use hyperlinks in other programs,
such as Word?
Please have a look at the following Knowledge Base articles to see if these resolve your problem.
OLEXP: Internet Shortcuts in Outlook Express Do Not Start Web Browser
You can access this article by clicking on the link below.
We are using exchange 2000 sever. and we have one user on
one machine that her emails take awhile to process, up to
3hrs possibly. She is running outlook 2002, with all
updates as of 10/9/03. I have figured in the past that it
was just the other servers the mail was going through that
was slowing it down. But when she uses, another persons
acount on another machine it runs fine. Is this and
outlook/machine problem, a server problem, or a problem
that is out of my hands? Or is there a problem at all?
>We are using exchange 2000 sever. and we ha...New emails with attachments not being delivered
When I send a NEW email with an attachment to my husband, it is NOT getting
delivered, however, when I FORWARD an email with an attachment, it IS being
delivered. I've tried sending different types of attachments (Word, JPG,
Acrobat) and it doesn't seem to matter. None of them (as new messages) are
delivered. I can send the same message to his home computer and it gets
delivered, it's just his work Outlook that seems to be the problem.
My email address is on his list of safe senders. He can receive emails with
attachments from others, including his home compute...Trouble sending emails #2
I am recieving emails, but every time I try to send one I get an error
message saying, "The server does not support the required HTTP methods. Ther
server responded 'Not Implemented'." I have no idea wht that means or what I
need to change. Help!
On Thu, 30 Dec 2004 15:05:06 -0800, Tina wrote:
> I am recieving emails, but every time I try to send one I get an error
> message saying, "The server does not support the required HTTP methods. Ther
> server responded 'Not Implemented'." I have no idea wht that means or what I
> need to change. ...How can I tell if an email I have sent has been opened?
As per subject.
You can try using a Read Receipt but many users block the return of them
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
you pay for it:
you can try it out for a short time...then you pay...but it's pretty
much guaranteed to get you the results you want...
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
Request a read receipt.
it...How do I export my emails and folders from Outlook to Thunderbird
I'm trying to export my email from and all personal folders from Outlook to
Thunderbird. Any help would be appreciated. Thanks, Sam
...email set up in publisher
I set up a newsletter and tried to email it, a setup wizard came up and I
cancelled it. now I dont have the send button for emails. how do I get the
wizard or send button back? Cassandra
> I set up a newsletter and tried to email it, a setup wizard came up and I
> cancelled it. now I dont have the send button for emails. how do I get the
> wizard or send button back? Cassandra
Start either Outlook Express or Windows Mail (whichever you have); this
should prompt you.
You have to have Outlook Express, Outlook, or Windows Mail set as your
default mail client to ...How to forward emails (unchanged) from one account to another
Assume I manage two different profiles and eMail accounts with my Outlook.
How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!)
to the other account ?
"Sven Claasen" wrote:
> Assume I manage two different profiles and eMail accounts with my Outlook.
> How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!)
> to the other account ?
Automatically forward messages to another e-mail account - Outlook -
Microsoft Office Online:
http://of...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...How do I set the number format to Base 12?
I would like to change the number format on my spreadsheet from Base 10 to
Base 12, eg. 12 bottles makes up 1 case. Therefore, if I were adding up three
different cells 9 bottles + 11 bottles + 6 bottles, my result should be 2
cases 2 bottles if possible 2.2 in a case column.
See http://www.cpearson.com/excel/fractional.htm for details.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Andrew Moore" <AndrewMoore@discussions.microsoft.com> wrote in
>...Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. Or, if
possible, the user could just select the icon (instead of selecting text).
Is this possible?
Use Data Validation for the list. Type in Red, Yellow, Green as the list.
This give the user the list to select from.
Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
If this helps, please remember to click yes.
"...multiple revieve of emails
I recieve multiple copys of emails in outlook. In some
cases I get 100 copys of the exact same message, in other
cases it is ok, then others many times Only one message on
Jim <firstname.lastname@example.org> wrote:
> I recieve multiple copys of emails in outlook. In some
> cases I get 100 copys of the exact same message, in other
> cases it is ok, then others many times Only one message on
Usually caused by 1) Send/receive interval too small or 2) server timeout
value too small or 3) rules that don't contain the "stop processing more
rules...Delay receiving email
We use Exchange 2000 and Windows 2000.
I have recently been expeirencing intermitent delays in receiving email from
two seperate domains.The delays are usually 3 hours but sometimes even
longer. In the header info the delay happens at the last hop before reaching
our domain. I have checked the exchange logs as well as the logs on our
gateway but they do not indicate any delay once we receive the email. I am
not sure what else I should do.
Any help would be appreciated.
...To write living will do I need special format
I just need to change and update a living trust
You should consult someone with the appropriate legal knowledge in the
jurisdiction in which you are domiciled.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"belladonna" <email@example.com> wrote in message
> I just need to change and update a living trust
...VISIO 2007 -Text direction
can some one tell me how to change text to be type in vertically. Under
tools, options there is no regional tab or under format text the change text
direction command does not work.
"kgbrat" <firstname.lastname@example.org> wrote in message
> can some one tell me how to change text to be type in vertically. Under
> tools, options there is no regional tab or under format text the change
> direction command does not work.
You can use the Text Tool (The A with an circular arrow around it) and gr...conditional format 04-15-10
I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?
I know I can do it with conditionale format for the cell itself but not
for another one.
Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.
> I want the color of the text in cell B1 to change depending on th...Special format
How can I change the format from numerical to English??
e.g.: 420 to Four Hundred and Twenty Only
It is called typing - UNBELIEVABLE
or SEARCH and REPLACE
but MS Office 2002 Chin support numerical to chinese:
123456789 -----> =
=3D.=3D" Can anyone help~~
>It is called typing - UNBELIEVABLE
>or SEARCH and REPLACE
...reply formatting in Outlook 2010
I set up my normal.email.dotm file to have 12 pts below each
paragraph, which helps formatting issues when sending emails to people
using gmail and other programs that interpret paragraph breaks
differently than Outlook.
That works just fine with new emails. However, when I reply to an
email, even an html email, the formatting is not applied. I can fix
this by choosing Format Text and then setting the spacing as per
above, but this is a pain in the neck.
Why don't reply emails use the same template? Is there a way to
template replies so i can use the same formatting?
thanks in advance,
...Show only extended description on receipt
I have RMS set up in such a way that it shows the extended description of the
items at the POS along with the regular description. When i print a receipt
both descriptions print.
Is it possible to print only the extended description, if so, how??
You might downloaded the receipt format or done yourself customization.
Just try to find first
Entry.Item.ExtendedDescription and if you see another variable called
Entry.Description Just remove the row or column with name "Entry.Description"
It will work, let me know or send me email address I have already the