Cells font colors
Does anyone know how to have a cell font change color
What I am trying to figure out is if cell A1 contains a number I would like that cell font to start off in red and if cell B2 contains a number have cell A1 change to red automatically
I think it is something like =IF(D4="",0[RED],100[GREEN]
And/Or Should I use Condiational Formating or a double IF?
You can't do it with cell formulas.
Take a look at Format > Conditional formatting.
You need the Formula is option and your formula should evaluate to
TRUE or FALSE
Norman Harker MVP (Excel)
Sydn...breaking text into multiple cells
Operating System: Mac OS X 10.6 (Snow Leopard)
Lets say I type "a b c d" into a cell. Is there a way I can place the cursor between "a" and "b" and then cause only "a" to remain in the original cell while "b c d" move to a new cell? <br><br>Thanks!
On 2010-05-27 12:53:39 -0400, Dwade01@officeformac.com said:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel Lets say I type "a b c d" into a cell. Is ther...Unsolvable cell naming question: Can anyone beat this one?
I am trying to copy and paste named cells from one workbook to another
without having the first workbook file name attach to the named cells. For
example, I am copying a cell named XYZ from file One.xls to file Two.xls. I
need to have cell XYZ NOT say One.xls!XYZ when it is entered into Two.xls.
Also, how can I get that message that asks if I want to use the cell names to
not pop up?
I think I understand what you're running into here.
If the cell you are MOVING refers to a named range in it's source workbook
that doesn't exist in the destination workbook, Excel will not ide...Windows users cannot open attachments created in Office 2008
Operating System: Mac OS X 10.4 (Tiger)
I "upgraded" [HA!] from Office 2004 to Office 2008 in January. I soon discovered that Windows users could not open Word files I created (regardless of whether I saved them as .doc or .docx, and regardless of their ability to open .docx files.)
I don't remember how I fixed the problem, and it's happening in Excel too. I wasted several hours trying to find a fix and I can't. Mac users can open the .xls file I sent, but Windows users can't. I had no trouble uploading the files to a Windows network d...Two different totals in one cell
C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0
As you can see, “A” (shown in columns D and L) and “AL” (shown in columns C
and D) are in two separate columns;
I would like to show their totals in two separate columns, i.e, O (totals of
all “A”) and R (totals of “AL”) in the example above.
Hope this helps.
On May 4, 4:27=A0pm, something68 <somethin...@discussions.microsoft.com>
> C =A0 =A0 =A0 D =A0 =A0 =A0 L =A0 =A0 =A0 O ...Change the numeric value of a dropdown to text value
I'm trying to email the values of form fields that I have created in a
form. So basically what I want to do is in the Subject I want to take
the "value" of the dropdown called dropdown1 and put it in the
subject. It is working but it is putting the numeric value instead of
the text value. How do I convert it.
Use the .Result, not the .Value
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
"Wo...How to retrieve number of files
What's the correct way to retrieve the number of jpg files in a directory?
Do I have to loop through each file, in order to count them up?
>What's the correct way to retrieve the number of jpg files in a directory?
>Do I have to loop through each file, in order to count them up?
Yes - use FindFirstFile (or CFileFind) to filter on *.jpg and
Yes. use ::FindFirstFile/::FindNextFile/::FindClose or use the CFileFind class of MFC.
On Sun, 4 Nov 2007 01:59:12 -0800, Charles Tam <CharlesTam@discussions.microsoft.com>
>What's the ...how do i create an action button in publisher?
ei am using publisher to creat email marketing publication and are looking to
add interactive buttons. I have looked every where in the software, could not
find it as easy as it is in powerpoint or access and excel? Is the function
hidden somewhere? I have seen it used on one of the template in publisher,
could someone help.I desperately need an answer. Please
What kind of action to you want Publisher to perform when you click on said
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"John" <John@discussio...absolute cell references
I've got monthly expense numbers in one workbook I need to
compare to monthly expense numbers in another workbook. I
insert a new column to calculate the differences in one of
the worksheets. Then I simply click to create the formula
that subtracts the expenses in the current workbook from
the expenses in the other workbook. Here's the problem.
I'd like to set up one cell with the difference and then
just copy it to fill in the rest of the months, right?
Well, for some reason, when I create the first cell, it
refers to the other workbook using an absolute cell
refere...When creating a toolbar manually...
Hello, I tried in my program to create a toolbar manually (I have a
class that derives from CToolBar) instead of modifying what the app
wizard generates for me. Everything works, except for one small thing:
The string associated with each button is only displayed in the status
bar while the button is being pressed, not when hovering above it. Can
that be fixed easily somehow? This was just an experiment and it's a bit
annoying that I could get everything working except when the button
string is displayed in status bar.
Here's how its created:
MyToolBar::Create(CWnd *parent...how do you stop editing the text in a created button
i'm in the process of setting up a spreadsheet, which happens to include
now the only problem i have is everytime i press the relevant button i've
created and assigned a macro to it goes straight in to the editing text mode!
is there any way of stopping that!
Sounds like a command button from the Control Toolbox.
Open the Control Toolbox Toolbar and click on the design button to "exit
This would be the top left button on the toolbar.
Gord Dibben Excel MVP
On Fri, 18 Nov 2005 08:18:13 -0800, "kara" <email@example.com>...tool tip text in excel button
I have added button inside excel sheet(not vb control). Is it possible to
add tooltip text for this?
I am able to set tooltip text for vb controls. But i cannot use these
controls inside excel sheet.
Thanks and regards
...insert number in column #2
I have a column with threedigits for telephone extensions. I want to insert
a digit before the three throughout the column as the extension has been
increased to 4 digits. Any easy way.../
In a blank column (say column H), enter
H1: =1 & A1
or, if you want them as numbers rather than text:
copy down as far as necessary. Select the column and copy it. Select the
original column and choose Edit/Paste Special/Values.
In article <Om6vrJpEIHA.3548@TK2MSFTNGP06.phx.gbl>,
"afdmello" <firstname.lastname@example.org> wrote:
&...Help with counting user entered text values
Version: Excel 2000
In Column G, I will have testers entering in their initals.
I would like to display the tester's initals in column H of another
worksheet with the number of times that set of intals appeared in
column G on column I of the other worksheet.
The catch is that I do not have a list of the testers initals ahead of
time, so I'll need to pull them from column H.
Thanks for any and all help in advance,
or if you don't want to see 0 if H10 is empty
I10: =IF(H10="","",COU...Memory Cell Could Not Be "READ."
I have Money 2K, WINXP Home, and until about a week ago I had no
problems updating. Now, most of the time, when I try to update the
Internet Information, I get an error message which reads:
The instruction at "0x600bb01c" referenced memory at "0x00000007"
The memory could not be "read." Click OK to terminate the program.
When this happens, my modem lights flicker as if it is trying to get a
response, but isn't getting one. After 10 seconds or so, I get the
above message. Every few days it works fine. I have Fidelity as a
investment, and I can always...Creating Views
I am using an "if" function to return information to me
from another worksheet, is there a way for the format of
the original to be carried with the cell value? I'm
trying to build a spreadsheet where I only enter data and
format in one workseet then use the other "tabs"
worksheets as "views"....
a formula cannot transfer format information
> I am using an "if" function to return information to me
> from another worksheet, is there a way for the format of
> the original to be carried with the cell value? ...Select cell from range based on input in excel xp
I have a worksheet with a table of data in it.
Based on user input generated from a pull down box that lists the values in
the first column and another pulldown that lists the values in the first row
of the table, how do I get the value of the field that is in the field where
the row and column intersect?
I want to read this value and use it in other formulas.
Once you get those values into the cells, you can use =index(match()) to return
the value from the table.
Debra Dalgleish's has some notes you may like:
dingy10...Time Format to Text Output
I run Excel 2K
I have a series of times that I download from the mainframe. (these are in a
23/09/2009 6:07:00 AM
22/09/2009 9:22:00 PM
22/09/2009 7:40:00 PM
I am in need of a formula that looks at these times, and based on their
values, displays a particular piece of text. (in this case "DAY", "AFT",
Any time between the following:
7:20:00 AM to 3:19:00 PM should display the word DAY
Any time between the following:
3:20:00 PM to 11:19:00PM should display the word AFT
Any time between the following:
1...what is 'too many different cell formats' reply?
Read this KB article
On Thu, 16 Dec 2004 19:29:01 -0800, "tommy" <email@example.com>
Check these out:
I think Gord meant to include this article link:
XL: Error Message: Too Many Different Cell Formats
Gord Dibben wrote:
> Read this KB article
> On Thu, 16 Dec 2004 19:29:01 -0800, "tommy" <tommy@discussions...Creating a self deleting executable using .NET
I am trying to create an application for the Windows Mobile 5.0 (or higher)
platform. One of the features of the application is that it has a panic
button that automatically closes down the application and deletes the
I have been trying to find a technical solution for this feature but it has
proven to be much harder than I thought. The problem is that the physical
executable file is locked and can't be deleted as long as the executable is
I found some quite interesting articles explaining the problem in more
detail and also explaining some possibl...Sequential numbers in a formula?
I have a few formulas (OFFSET & MATCH) which are the same (with relative
references chanfing accordingly) and occupy cells B2:B500. In each
formula one of the function arguments refers to a single cell in the
adjacent column i.e A1:A500 which contains the numbers 1 to 500 (and the
column is hidden as the numbers are needed only in the formulas and not
to be displayed).
The numbers are used to give the relative row number in the ranges used
by OFFSET. So, the first formula uses 1 (via B2) and the second formula
uses 2 (via B3) and so on.
My question is: Can I somehow refer to a ...Auto Adjusting Text Box
Is there any way to have the text box auto adjust the height in a protected
form according to the amount of text a user inputs? Thanks! Jae
...How do I change the size of a text form field box in Word?
I f more text is typed in the text form field box then its standard size the
other form fill boxes to the right all move over to accommodate the
additional text. Is there a way to increase the text form field box?
Place your form fields inside (border-less) table cells whose dimensions are
Microsoft Word MVP
"Blink" <Blink@discussions.microsoft.com> wrote in message
>I f more text is typed in the text form field box then its standard size
> other form fill...Creating forms.
Your question should have appeared here...
If it had, my answer would have appeared here...
On 17/01/08 1:44 AM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
Don't wait for your answer, click here: http://www.word.mvps.org/
Please reply in the group. Please do NOT email me unless I ask you to.
John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:email@example.com...Update field within a text box
I'm using Word 2007.
I created a template with a REF field in a text box that refers back to a
bookmark created with an ASK field earlier in the document. When I create a
new document using this template, all of the ASK and FILLIN prompts come up,
but the REF field in the text box does not update automatically. If I click
in the text box and hit F9, it will update, but I would like it done
automatically. Is this possible?
No, even Ref fields that aren't in text boxes don't update
You can go to Print Preview and back to update all the ...