Format single words in cells
Is it possible to use conditional formatting on individual words inside text
cells,rather than on the whole cells? I have a column filled with quotations
where I need a keyword to be highlighted in each cell, not the whole cell...
Search & replace too seems to be operating on the formatting of whole cells
rather than single keywords.
No, it is not possible to get conditional formatting to highlight a
single word (of many) in a cell. You would need a macro to do that.
Hope this helps.
On Nov 17, 2:01=A0pm, Gabriele <Gabri...@discussions.micros...duplicate SMTP email issue with Exch 5.5 sp4
I am "reposting" this to try and get more feedback.
We have a exch5.5 sp4 environ with multiple servers (1 mail domain). We have noticed that if you connect directly to port 25 and send a single email to both a DL (with User A inside) and User A, User A receives 2 copies (exact duplicate) of the message. This only occurs via straight SMTP. Webmail (yahoo, excite) and Outlook do not cause this issue
Has anyone else encountered this issue? What was done to resolve it? While there seems to be significant suspicion
of sp4 as the root cause, is anyone running exch 5.5 sp4 or high...Combining Text in Multiple Cells into One
I am trying to combine text that is in 4 different cells into one cell.
D1 E1 F1 G1
FIRST FLOOR PAVING PLAN DRAWING
When combining these cells into one, you would get:
FIRST FLOOR PAVING PLAN DRAWING
Is there a simple way to do this? Would it be a formula in H1? If so, what
Thanks for your help.
Brianna, how about, =D1&" "&E1&" "&F1&" "&G1
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit ...Arrow keys move work sheet and not from cell to cell???
I apparently have inadvertantly checked something so that when I use my
arrow keys I do not move to the next cell. Rather the work sheet itself
moves. I would deeply appreciate any help here. Thank you in advance for any
Touch Scroll Lock
Gary''s Student - gsnu200847
> I apparently have inadvertantly checked something so that when I use my
> arrow keys I do not move to the next cell. Rather the work sheet itself
> moves. I would deeply appreciate any help here. Thank you in advance for any
>...Referrence a total in a cell on another worksheet
I have created a workbook to track all my bank deposits, automatic deposits,
and credit card receipts.
Each worksheet has a cell that contains the total receipts from the deposit
Can I referrence this cell on another worksheet that will total all
worksheet totals to date? In other words, I would have a running deposit
(income) total for the year on one worksheet.
Modify to suit for your first and last ws.
Microsoft MVP Excel
"AndreaV" <AndreaV@discussions.microsoft.com> wro...Data for Chart with Blank Formula Cells
I am trying to chart a worksheet that contains many formulas. When th
result of the formula is zero, the cell is instructed to leave the cel
blank (which is important to the information being tracked). However
when I chart the data, it charts a ZERO for the cell.
I tried the interpolate feature, but because the cell has a formula i
it, it is not being read as "blank", even though the value is blank.
Help! If week one is 2, week three is "blank" (remember, cell actuall
has a formula that is returning the blank), and week four is 6, I do
get my chart to interpolate from...Access a cell's Formula, rather than Value
I would like to modify this formula so that I use the formula of the cell
specified by x,
rather than the value stored in the cell.
=CHOOSE(x, Sheet1!A1, Sheet2!A1)
Not possible, you would need VBA for this. I can't see how by using CHOOSE
you would be able to do this even if it was possible to get the formula to
replace x since x should be an index number either 1 or 2 (in this case) if
you have 2 values? Or have I totally misunderstood?
"John Broderick" <email@example.com> wrote in message
news:e1RJAHYmHHA.455...How do I enter cell data in a footer
I'd like to enter a sum total from a cell into a footer on a chart to show
how many reponses there were to a feedback questionaire, that is assuming
this is possible of course.
You can add a linked textbox to the chart.
With the chart active use the formula bar to type in the cells address,
including sheet name, so for example the sum total is in cell A12 on
sheet1 the formula refrence would be,
when you press Enter the textbox will be added to the chart. Position
and format as required.
> I'd like to enter a sum total from a ce...Data validation based on another cell
Im not quite sure what to put in the title, but heres my problem:
I want prevent people from inputing into a cell if other cells have
been filled in.
A1 has no value
B1 has no value
C1 has X
D1 then cannot have a value because A1:C1 has an X in one of the other
:: but if you make C1 have no value then D1 would be able to input an X
into that cell, however
then the other cells you would not be able to.
Im assuming you would use data validation, things ive tried is custom
data validation with formulas
such as COUNTA(A1:C1)>2, also tried IFTEXT(A1... i tried a few forumlas
which...How do I break up a long text cell into shorter ones withoug spli.
I have a txt cell with between 1 and 200 characters in lenght. I'm trying to
break it up into 1 to 6 seperate cells, each with up to 40 characters in it
without splitting up any words. So if the 40th character splits a word, I
want to split it at the previous space. Then I want to go from that character
forward for the next cell, and so on.
date>text to columns. use fixed width. set the break where
you want it by clicking on the number like just above
where you want the break.
>I have a txt cell with between 1 and 200 characte...Spread content of 1 cell over many cells
I just performed the "Text to Columns" function in Excel and it didn't do exactly what I was hoping for. I have a spreadsheet with 1300 addresses in the following format:
City, State Zip
I want to change it so that Street Address is a separate column and City, State Zip is a separate column (ie: for a mail merge)
I tried using "Text to Columns" and it moved the top line (street address) to a new column, but left the adjacent column in the same format (as above). It's almost like it copied the top line and pasted it in a new column. I want it to act...Hyperlink Text in Cell
I thought this would be pretty straight forward but I guess I was wrong. I
want to create a hyperlink to a web site within a cell. But, I have a large
amount of text in the cell and I don't want the whole cell hyperlinked - just
the one word.
Can this be done?
Not directly. I've faked it by formatting the word(s) as a hyperlink and
placing a borderless transparent textbox with the hyperlink over the
words (set to move and size with cells).
In article <2A99C38C-1F27-4FE9-B600-DDAFDA4FF5E3@microsoft.com>,
"Jason" <Jason@discussions.microsoft.com> wrote...How can I enter carriage returns into text within a cell in excel
I am trying to use excel to create a table full of text. I would like to be
able to format the text within the cell (e.g. entering carriage returns to
put some text on a separate line). I can't seem to make this work. Any
You need to use Alt-Enter to add line breaks within a cell.
> I am trying to use excel to create a table full of text. I would like to be
> able to format the text within the cell (e.g. entering carriage returns to
> put some text on a separate line). I can't seem to make this work. Any
Press Alt+Enter withi...Displaying document settings
Is there any way to display the various document settings in the body
of the document so that they print?
I'm referring to paper size, orientation, margins, etc.
On Sun, 07 Feb 2010 17:33:54 -0800, Sesquipedalian Sam
>Is there any way to display the various document settings in the body
>of the document so that they print?
>I'm referring to paper size, orientation, margins, etc.
There's nothing built in for that (you can set an option to print
document properties, but that's the information in the File >
...How to check if the values in a range of cells are greater than 0
Basically I want to check like IF(B3:B5 > 0,B1), if any of the values in B3
to B5 cells are greater than 0 then I take the value from the cell B1. How
to do it in a simple way.
If I use directly the above mentioned formula, it gives me a #VALUE error
where you decide what you want the something_else to be (eg 0 or "").
Hope this helps.
On Mar 19, 10:19=A0am, DP <D...@discussions.microsoft.com> wrote:
> Basically I want to check like IF(B3:B5 > 0,B1), if any...cell color versus gridlines
The default white cell color causes my eyes to strain after a while. In
Office 95 and 97 I somehow made all the cells a very light gray by default
and had the gridlines in black by default. For the life of me, I can't seem
to do this in Office 2003. Any tips?
Prepare an empty WB and pre-format it to your convenience.
Save it as a TEMPLATE under the name: BOOK.XLT in: C:\Program
* Close and reopen "Excel".
> The default white cell color causes my eyes to strain after a whil...Must display as: send on behalf of XXXXXXXX
I hav exchange 2003 and xp pro clients. The PA has the right to send on
behalf of the GM but in the From: field is showing that the mail comes
directly from her which they don't want. How can i change this so that it
display : On behalf of the GM(the name of the name)
On Thu, 18 May 2006 22:56:01 -0700, Craig from Huguenot
>I hav exchange 2003 and xp pro clients. The PA has the right to send on
>behalf of the GM but in the From: field is showing that the mail comes
>directly from her which th...increase number of days displayed
Is it possible to increase the number of days displayed in Outlook Today as
in this article.
No... but you can always try using a higher #. (AFAIK, they did not raise
the limit, but I haven't tried it either.)
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips.net/
Outlo...Issue with Rules in Outlook
Have been trying for a while to resolve the issue of a email rule only
running at the time of creation and never works next time on messages
from same sender to move mesages to correct folder.
1. Wizard used
2. Trigger is sender ex. Columbia House - DVD
3. Action - move to products folder
result - works when created but not on the next set of messages
Assistance would be greatly appreciated.
What type of email account do you have? Do you have any other rules and do
they work correctly?
Diane Poremsky [MVP - Outlook...Excel 97 Comment Display
Is there a way to cause a comment associated with the
active cell only, to be visible, regardless of whether the
mouse pointer is "hovering" over the cell? As the
user "tabs" or "arrows" across the worksheet, I would like
the comment for the active cell to pop up, while comments
associated with the inactive cells remain invisible.
Put this in the worksheet code module (right-click the worksheet
tab, choose View code and paste the sub into the window that opens):
Private Sub Worksheet_SelectionChange( _
ByVal Target As Excel.Ran...Username Display Problem
We are using Outlook 2003. When I rename a user in active due to marriage,
change the user's active directory account name to reflect the change. I do
see the recipent policy take affect and it changes their email address.
However when in Outlook 2003 and I start typing their name it comes up with
part of the old name. Example:
'Prince Albert' displays when typing in the To: field as 'Prince Albert
If I rename 'Prince Albert' to 'Prince Bumble' the display when typing in
the To: field displays as 'Prince Bumble <PAlbert>...Fill-colour a cell dependent on formula
Formula in C1 - =IF(A1<B1,"Green",IF(AQ<B1/0.95,"Red","Amber"))
How can I fill-colour the cell to change to the colour (Green, Amber or Red)
rather than show the word of the colour.
Many thanks in advance.
Take a look at Conditional Formatting in XL Help.
In article <68E046F9-A489-4C1A-BCC1-49692478DAE1@microsoft.com>,
Kim Duffy <KimDuffy@discussions.microsoft.com> wrote:
> How can I fill-colour the cell to change to the colour (Green, Amber or Red)
> rather than show the word of the colour.
...Money login issues
Any news on the broken Microsoft Money login and passport issues?
...Moving Outlook data between hosted Exchange provider issues
I have been using hosted Exchange for the last couple of years provided
by a third party accessed via RPC over HTTPS and due to a new job am
moving to another third party Exchange provider.
My mailbox is currently around 400Mb and up till now have been using
Outlook 2007 which I intend to continue using.
I tried to export my mailbox using File > Import/Export > Export to file
> Personal Folder File (.pst) and select complete mailbox including sub
folders. This creates a .pst archive of about 400Mb containing my
mailbox. I then changed the mail account settings to point...how do you format a row of cells based upon a value in another ce.
how do you format a row or a range of cells based upon a value in a cell not
included in the conditional format?
select the cells to have the conditional formatting on them
choose format / conditional formatting
choose formula is
type the criteria (ie =$E$1>50)
click the format button to apply the formatting.
"hazenb1" <firstname.lastname@example.org> wrote in message
> how do you format a row or a range of cells based upon a value in a cell
> included in the conditional form...