Cell color change with the input of color coded text
Can the cell color change with the input of color coded text (ie: R - Red =
fail, P - green = pass etc.)
have a look at 'Format - Conditional Format'
"newby blues" wrote:
> Can the cell color change with the input of color coded text (ie: R - Red =
> fail, P - green = pass etc.)
I have two sentences typed in a cell which has been
formatted to autofit row height, and wrap text, and yet
the cell will not adjust to two rows of typing, a total of
32 words, or a total of 146 characters including spaces.
I don't think that's too much to type in a cell in Excel.
One can only guess what the problem is. But I suspect the
spreadsheet might be protected.
>I have two sentences typed in a cell which has been
>formatted to autofit row height, and wrap text, and yet
>the cell will not adjust to two rows of typing...TEXT Function: please help
I have a sheet that keeps track of MAC to IP adresses. I've created a
formula that will output the required format for DHCP server import.
The formula was quite long and it was suggested to use the TEXT function .
Thanks to Bob Phillips and my friend LavaDude my rather legthy formula
has been reduced to the folowing, but it doesnt work correctly.
hardware ethernet "&TEXT(D2,"...How to use of brackets  and () in search
Searching in the inbox for texts like [work] or (plant) will make outlook
search for work and plant. Without the brackets  or ().
How can you search with brackets ?
(Outlook 2007 12.0 SP2)
You can't do that with Instant Search since the index is word based and not
character based. You'll have to use Advanced Find instead.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
...Counting text in a column
I used to think I was good at Excel until this stumped me.
I have a column with a variety of text in each cell.
Is there a formula or way I can take the whole column of data and hav
it come back with something similar to:
bob = 2
for all the variables in the column?
Please help, I am dying over here
prom4x's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2901
View this thread: http://www...Formatting text and date together
How can I format a cell to hold text ("Last update:") and a date whic
is obtained from another cell? The Formula reads something like +"Las
update: "&f2. The date comes out as its numerical value.
Is it possible.
Brisbane Rob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2509
View this thread: http://www.excelforum.com/showthread.php?threadid=49227
Use the text function to format the numeric component to suit your needs,
along the lines of ...getting editbox text
Is there easy way to get address url entry from that edit box in IE? I can
get current url displayed but don't know
how to get what user type in before navigation.
...Problem when converting handwriting to text
I have a tablet, Motion Computing LE1700, with Windows 7 Professional 32
bits English. I installed Office 2007 and OneNote 2007 in Spanish. I take
notes sometimes in English, sometimes in Spanish. I thought that OneNote
could convert handwriting to text in English and Spanish but it is only
working in English. When I try to convert handwriting in Spanish (choosing
Spanish as main language) OneNote does nothing. No error, no messages,
absolutely nothing. The same behavior happens with OneNote 2010 Beta Spanish.
Is it correct? How could I convert Spanish handwriting to te...Attn Publisher Users: Setting your Text Defaults!
Ok, wanna know how to save your text defaults for all future publications
for Publisher 2002/2003. We have just discovered that you do NOT need the
add-in that we developed. This feature has been there all along, since
Publisher 2002 as a matter of fact.
The Normal.pub feature (like the normal.dot feature in Microsoft Word) is
actually present in these last two versions. Yes, it has been there all
along! Thanks to Alex at Microsoft, as he was kind enough to point out after
all these years that it truly does exist.
I have created a tutorial, which is very simple:
http://www.publishermvp...Print a text message to indicate no records in sub report
Hope I can explain my problem.
I have a main report for a number of sites.
It has 5 sub reports some of which may not contain data for a particular site.
Would like to indicate on the report that there is no data for this site on
this sub report.
Create a text box on the main report, and set its Control Source to
something like this:
=IIf([Sub1].[Report].[HasData], Null, "Nothing for this site.")
Replace Sub1 with the name of your subreport control.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com...Search results
Is there a way to have the search results box diplay a
darker border or shade the box?
...highlighting text box if...
Is there a way to highlight a text box in a form if say, an expiration date
is past due? If so, how?
Thanks for the help,
Message posted via AccessMonster.com
Never mind... I have tunnel vision right now. I figured it out.
>Is there a way to highlight a text box in a form if say, an expiration date
>is past due? If so, how?
>Thanks for the help,
Auburn...In Excel -- How do I cross out (strike through) text?
In Exel -- How do I cross out (strike through) text?
Select the cell you want to format. Then, go to the Format menu,
choose Cells, then the Font tab. There, check the "Strikethrough"
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"E.Walsh" <E.Walsh@discussions.microsoft.com> wrote in message
> In Exel -- How do I cross out (strike through) text?
...Sorting by Text field of numbers
I am using Access 2003.
I have created a database to help me files by "Lot#'s". Our lot numbers for
one of our products is all over the place so I created the Lot # field as a
text field. Ex: 02-01-01, 10000272925, 10-06-02-04-06 and 1503011 A1-02.
Why does access put - 1000272925 before 10-06-02-03-05? Does this look right
My thinking is that "10" comes before "1000272925". What affect does the
"-" have in sorting the numbers. Would I be better off to put a space
instead of the "-"? Can anyone help me ...Yahoo text has multiple deletions since '08 Word was installed
Operating System: Mac OS X 10.5 (Leopard)
I've probably made some basic error with installing Office: mac 2008. Since doing so, I can't read much of anything on Yahoo. Many letters are missing; some are squished together. Is there are a problem with font compatibility? I'd welcome any suggestions on how to fix the problem. Otherwise, I'll need to uninstall and try again, which I suppose is not a bad initial strategy. Please help.
Simply shut the computer down, turn it off, then restart.
When you restart, you force a rebuilt of the font caches, ...Searching for a mail reflector tool for ex 2003
i am searching a mail reflector tool for exchange 2003. I found
LISTSERV but it is a standalone application. Can someone help?
trojmok <firstname.lastname@example.org> typed:
> i am searching a mail reflector tool for exchange 2003. I found
> LISTSERV but it is a standalone application. Can someone help?
What exactly is it you're looking for? "Reflector" generally means you want
your mail, either inbound or outbound, delivered o...How do I prevent pictures form moving when adding text?
Right click the picture, format picture, Layout tab, Object position, change to
"Peggy" <Peggy@discussions.microsoft.com> wrote in message
Is there a way when inserting pictures and clipart of have them all wrap the
way you want when you bring them in. Some option or setup or something for
when you insert pictures? Everytime I insert pictures I need to change the
"Mary Sauer" wrote:
> Right click the picture, format picture, Layout t...Change of text or background color doesn't change on the screen.
In Excel, whenever I change the color of the text or highlight a cell with a
different background color, it's not being reflected on the screen. Any
An idea, yes:
may be the conditional format.
If for example the cell is supposed to become red when the value is
null, and the value is null, then it will stay while the condition is
true. Even if you change the "regular" color (it will appear only when
the condition is false)
Under Options, View, Colour is Colour set to 'Automatic' ?
Does this happen on any specific sheet or in all sheets, in an
specific ...Text over a picture
I am trying to put text over a picture. The picture is in place, then I put
a text frame over it. The " fill" covers up the picture and I can't figure
out how to make the text over the picture, but still see all the picture .
It is a black and white picture and the letters are going over a black part
so I was the text white so it shows up, but I can't figure out how to do it.
Basically in the end I am trying to make the picture look like a watermark
behind the text. Help!
What format is the picture?
The text box can be made transparent, select the box, ctrl + t.
...Sort numbers with text in ascending order
I am having a difficult time sorting the following list:
MY List How Excel Sorts I Need
2148-00 1472-00 171B-00
1480C-00 1480B-00 171C-00
1480B-00 1480C-00 1472-00
1472-00 171B-00 2148-00
171C-00 171C-00 1480B-00
171B-00 2148-00 1480C-00
I have tried formatting numbers as text and other options. I am at my
wits end now. Is this sort even possible? Please help.
Where is the logic to your sort please?
If you can identify that then a sort may be possible! ...outlook express cant see message body text
I can see the list of messages, for example in the inbox
with "from", "subject", received, etc but if I open any of
the messages the body of the message is blank. If I do a
save-as to a text file I can open the file with notepad
and see the message text. Any ideas?
...Locking a Text Box
Hi all, hope someone can help with a text box locking problem. I need
to lock a text box on a switchboard so that it can not be deleted by
someone else. I am designing a database for a friend's work but want
my name and address in a text box as the designer on the switchboard
to remain. I know that my friend will make changes and there is
little I can do, but I don't want my name and phone number deleted
from the switchboard. Is there anything that I can do.
Thank you for any help you can give.
I'm afraid there is no way to allow someone to change some aspects...Highlighting text problem!!!
In Publisher 2003 when you highlight a piece of text it always auto
highlights the end of paragraph symbol. This is a pain as when you try to
alter things like the kerning, the end of paragraph symbol is included and
gives an uneven stretch. We have initially got around the problem by
physically putting in a space after the text so you can then only highlight
the text and the end of paragraph symbol is not auto highlighted. Surely
there must be a better way to get around this problem (please don't suggest
better mouse control) which only seems to effect 2003, all other versions are ...SEARCH AND REPLACE
Historically, when I select cells and do a "replace all" (via Ctrl+H) Excel
reports the number of replacements it is making (same as with Word). I have
just started at a new location-office. Excel does not report this. It
replaces without asking for confirmation. I cannot find settin or info that
will cause it to report as discribed above.
Help, please (solution, info, etc).
When you use Ctrl+H to make replacements and fill in the
from and to fields. Do you see buttons on the right for
Find next, Close, Replace, Replace All
sounds like you want to u...IF or SUMIF to bring back text?
I am trying to match departments which have two different titles. For
example, there are 50 departments that are futher classified into 150
sub-departments. I do have the data showing departments and their
corresponding sub-departments in two columns. On another sheet there are
only sub-departments and I need to assign the corresponding department name.
I have tried IF and SumIf but neither works. Basically, I need a formula to
match the text and bring back the text for the sub-department.
sounds like you need VLOOKUP
> I am...