how do you Create flashing Text
I am creating a newsletter and want one of the titles in the newsletter to
flash or blink. How do I do this?
Ask this here:
Mary Sauer MVP
"lukieguy22" <firstname.lastname@example.org> wrote in message
>I am creating a newsletter and want one of the titles in the newsletter to
> flash ...Conditional Formating #18
I would like to apply a conditional formating to fill with a red colour some
Excel cells when the computer calendar gets some date, I would like to fill
that cells when "best before date" of some pruducts gets that date with the
Thanks a lot.
If cell A1 is active:
CF1: Formula is =TODAY()>=A1
In article <13BD3AC5-9DFE-4C53-BA91-440BC506B82E@microsoft.com>,
Pedro Mestre <PedroMestre@discussions.microsoft.com> wrote:
> Dear all,
> I would like to apply a condition...Preserve format in pivot table
I have a pivot table where I formated the numbers using
the "accounting" format. When I refresh the table, it
goes back to the "general" format.
How do I keep the "accounting" format when I refresh?
Things to try -- if they don't work, you could record a macro as you
refresh and reformat the pivot table. Then, run that when you want to
Set the pivot table to preserve formatting:
--On the pivot toolbar, choose PivotTable>Table Options
--Add a check mark to 'Preserve formatting', click OK
Depending on your version of Excel, you ...Formatted text in QuickParts/AutoText
I'm back with another issue. I cannot seem to get my saved QuickParts to
hold its formatting, specifically, underlining. So, in reading the boards, I
decided to use AutoCorrect instead, and apply formatted text settings. While
the text shows up formatted in the little window in the AutoCorrect tab, when
I insert it into my document, the underlining ONCE AGAIN is gone!
Is anyone else having these issues with autotext / quickparts functionality?
This entire feature in Word 2007 just does not work properly in so many ways
for me. Of course I'm not discounting us...How do I extract text content from an exported .rwz file
Outlook 2003, Office Pro -
When you export Rules and create a .rwz file, the file is not a pure text
file as it seems to be loaded with null chars. I would like to extract the
long list of spam words used in a particular rule. Is there a way or a
utility which will remove all the nulls from the file so I may edit it to
get the contents I want ?
The alternative storage location is not any easier - trying to get the same
info, as it is similarly stored, out of the registry. :(
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and R...If/then to print text.
I want to use a formula so that when a value over zero is put into one cell,
a line of text prints in another cell. I know it is an if then function, but
I've forgotten the exact formula and the way to encode the text message in
> I want to use a formula so that when a value over zero is put into one cell,
> a line of text prints in another cell. I know it is an if then function, but
> I've forgotten the exact formula and the way to encode the text message in
> the formula.
=IF(A1>0,"print this text","prin...Getting text from hidden text producing error
I am using code to populate a drop down from hidden text (in text formfields) in a Word form. The code works great, however, I have now hidden the section that contains the text form fields and the code returns an error. Is there something I should be inserting in the code so that it can cope with hidden text/ bookmarks? I don't want to unprotect, unhide, run existing code, and then rehide and reprotect as this is cumbersome.
Select Case ActiveDocument.FormFields("scheme").Result
With ActiveDocument.FormFiel...TEXT problem...
I have a cell with the following formula:
TEXT(e2,"mmmm dd, yyyy (CSC)")
cell e2 contains a date formatted value, "March 27, 2004"
Question, although the formula appears to work in terms of
converting the date to a text datg (for manipulation
later), why does the result yield "March 27, 2004 (C0C)"
instead of "March 27, 2004 (CSC)"?
For some reason, the function is replacing my 'S' for a
Its because the S is being interpreted as seconds. Since you
(presumably) have a naked date in E2...Extending formulas/formats with imported tata
I have a worksheet that includes imported data. Several columns consist of
row-specific formulas. How do I get Excel to automatically adjust these
columns to account for more or fewer rows whenever I import new data?
Example 1: I import a file with 100 rows. I create the formulas on columns
outside the imported data and copy these formulas down the 100 rows. The
following week, I call up this spreadsheet, and using Data | Import External
Data | Edit Text Import, I import a file with 145 rows. The formulas on the
first 100 rows recalculate properly. But the final 45 rows don't...Getting details and adding text to the receipt
I want to get some details from the Receipt and also want to add some text
to the receipt... How can I do this...
I tried to this with session.variable was not able to successed. I want to
do this through VB.Net... A example in VB will also do for me...
Waiting for your reply... :-(
Can provide a sample of what you have tried?
"Vicky" <Vicky@discussions.microsoft.com> wrote in message
> I want to get some details from the Receipt and also want to add some
> text...Formatting Cell Text
Can you set a text up to display number's in foot and
inches example 12 would appear as 1' 13 would appear as
this is not possible with formtas. You have to use a helper column for
this. see Chip's site for some more information:
> Can you set a text up to display number's in foot and
> inches example 12 would appear as 1' 13 would appear as
> 1'1' etc.?
Take advantage of a great deal
...IF to check color of text
I have a calendar made up of my work schedule. I have the days that
am working a font color of black. I have the days that I am off a fon
color of light gray.
I'm looking to use an IF function in which detects the font color, an
if true, add eight, otherwise add zero.
Is this possible?
Message posted from http://www.ExcelForum.com
You have to use a userdefined function.
See Chip Pearson's site for an example:
"eckaner <" wrote:
> I have a calendar made up of my work schedule. I have the days that I
> a...referencing conditional formatting
Using XL2000, I have made a simple inventory/order workbook consisting of 2
sheets: Food Items and Order Sheet
Currently in J4 of 'Food Items'
Copied down to J41
This results in the flag to reorder when inventory reaches a certain level
Currently in A6 of 'Order Sheet'
=LEFT('Food Items'!I4,1)*COUNTIF('Food Items'!J4,"Reorder!")
Copied down to A43
This tells me how many cases to order
Works as intended, but I would like something to dazzle others <g>
First I would c...Dupe Text Attachments
All of a sudden, starting yesterday, every message I receive has an
attachment with a .TXT file with the contents of the message. It's like
getting duplicate messages. How can I correct that? Help...
I am having the same problem. I have isolated it to plain text messages sent
from Outlook 2000 clients. It doesn't appear to happen with 2003. It also
just started happening a couple of weeks ago.
> All of a sudden, starting yesterday, every message I receive has an
> attachment with a .TXT file with the contents of the message. It's l...convert text to numeric values
My database (Access 2007) keeps track of bids from FE colleges. These are
made in an academic year (these span two 'calendar years e.g. 2009-10 for the
current academic year). Sometimes the bids are carried forward to, and paid
in, the following academic year. The 'Bid Year' and 'Paid Year’ are text
fields. When designing a query that will give me the total sum of bids made,
bids approved and bids actually paid, I can do separate ones based on 'Bid
Year' and 'Paid Year' but the totals are quite often different if a year has
bids that have been carr...Pasted text splits into separate text boxes.
Recently upgraded my Publisher program. When using a text box from a
template, and I try to paste text, it breaks the text, line by line into
separate boxes within the text box. I never had this problem with my
previous Publisher program. What's up with this?
A JackBird <A JackBird@discussions.microsoft.com> was very recently
heard to utter:
> Recently upgraded my Publisher program. When using a text box from a
> template, and I try to paste text, it breaks the text, line by line
> into separate boxes within the text box. I never had this problem
> with my previo...Excel Options
Can anyone tell me how I can have the default setting in
Excel set to NOT wrap the text?
I do a lot of copy/pasting and it drives me nuts to keep
having to deselect the wrap text.
For me, the default is off.
But I think excel tries to help. If you paste text into a cell and that text
contains alt-enter, then excel says: you need wraptext on! And does it.
You could give up trying to do it after each paste and just do one mighty change
(all your cells selected) when you're finished.
or you could use a macro and assign it to your favorite shortcut key:
Sub t...Adding text to all outgoing messages...
I would like to add a text message to all outgoing mail messages. How
can i do this ?
for your text (assuming you are usaing exchange)...
They provide a free version that does disclaimers.
"Carlos Mendes" wrote:
> I would like to add a text message to all outgoing mail messages. How
> can i do this ?
check this vbs sample
"Carlos Mendes" <email@example.com> schrieb im Newsbeitrag
news:51esu09sh1tpfl4usbfbht083cq970...conditional formatting question #9
I have a spreadsheet that gets updated monthly and looks like the example below
Jan Feb march April May June
21,000 23,500 22,224 22111 20,111 25,000
I've asked this question before and have gotten great tips but each month
when refesh the pivot table it looses all the conditional formatting and I
start over again.
The conditional formatting needed is if #'s go down for three consecutive
months in a row they are highlighted in red. I need the first month of
dropped revenue example above would be March in yellow and then t...Unable to use original text prefix character
I want to use a '>' to prefix original text in replies and forwards. I
have it set up to do so in my options, but it still just uses the blue
bars around the original text.
I think the options are just being ignored. Even if I force plain text
format, it still composes in HTML unless I change it manually in the
new message's toolbar.
Anyone have any ideas on this? My IT guy cleared my profile and it had
no effect on the problem.
firstname.lastname@example.org <email@example.com> wrote:
> I want to use a '>' to prefix original text in replies and fo...Get Rich
Take advantage of a great deal
....ps1 attachment preview with text previewer
How can I get .ps1 files to preview with the built-in text preview handler.
I have unblocked the .ps1 attachments so I can see them (in the registry)
and I have associated the .ps1 extension with the built-in text previewer
but I still get the message "This file cannot be previewed. Try opening the
file in the program in which it was created". I am an instructor and I have
students send their homework in via e-mail. Often times I like to quickly
view the scripts without saving the attachment. This is not a security
risk because you can't execute a powershell script dir...Automatic colors for text
Can you set excel to automaticly fill in a cell color for specific text
- check out conditional formatting on the format menu
if you'ld like further assistance, please post back with more details
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mogravy" <firstname.lastname@example.org> wrote in message
> Can you set excel to automaticly fill in a cell color for specific text
...change color if text is = or not, to text in other column
I am taking practice tests. ColB contains text (the correct answers). ColC
contains text (my practice answers). I want the cells in ColC to turn green
if my answer is correct (matches the text in ColB) and turn red if it is
incorrect (does not match the text in ColB).
I can't figure out how to get it to apply Conditional Formating on the
columns. It wants me to apply it to only a single cell. I've also tried
copying and pasting special just the formatting. It turns the cells in ColC
green if they match cell B2 (not the corresponding answer that is in the same