Data Validation with colour #2
Is it possible to have Data validation for a list of values but add
colour to a selection of them?
At the moment they change back to the default colour?
May be an IF Command
Like IF = 6 THEN RED
Message posted from http://www.ExcelForum.com/
I'm not exactly sure what your question is, but you might be able
to use Conditional Formatting from the Format menu to accomplish
what you want.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"ianripping >" <<email@example.com> wrote
in mess...Office X Mac Word
I just installed Office X for Mac. I started using Word and I wanted
to change the font. So I used the drop-down font menu and type in "t".
Usually in Windows it scrolls immediately to font styles starting with
"t". To my dismay, it doesn't do that. I have to manually scroll down
& down to go the font I want.
Does anyone know if there's any update that I have to install in order
to get this feature? ( i don't even know what to call it)?
No, I don't think that feature is available in Office X. However, there are
some updates you shoul...Bar charts with negative values and label position
In a bar chart containing both positive and negative values, the X-axis
labels (indicated by the Category X series) display over the negative bars of
the chart. Is there a way of moving the negative value labels to the right
of the axis? I have seen this in both Excel 97 and Excel 2000.
1. Create a spreadsheet with the following in cells A1:B5:
2. Select A1:B5.
3. Press the chart wizard button and choose a bar chart.
4. Click the FINISH button.
I have seen a similar post for this issue for Works for Windows (Article ID
: 113...Word X and Word 97
I am sending Word X documents to clients using Word 97 and Word 2000=20
and they are unable to open them. What can I tell them to do in order =
open my documents?
Make sure a ".doc" extension is added to the end of the filename of the Word
Some other compatibility issues are mentioned here:
This process might work to open the files: Tell the user to open Word on
the Windows machine, and then go to File -> Open. Tell him/her to choose to
show "All files (*.*)", and then tell him/her to navigate to and op...Foreign fonts (special characters) not shown in word/excel
I work a lot with Hungarian translations at the moment. There are 2
characters that are not shown in office documents (neither 98 nor 2001). The
characters missing are the "o" and "u" with "Doppel-Akut". Their unicodes
are 337 and 369. The characters are shown without any problem on the PC.
We need to put the Hungarian translations into QuarkXpress. Even if I copy
the text out of a PDF the characters are already missing in the clipboard.
Apparently, there is an Office multilanguage kit for Mac that installs the
Arial font completely new so that all characte...How to create customize chart?
How to create chart with symbol or picture instead of bar?
For example like below:
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=9576b37e-dc95-4180-9985-7fbf7b6907af&dg=mic...running a Macro in 2007 which was created in 2003
Hi there, I hope you can help, I am not VB literate unfortunately but I am
trying to run a macro with the following line of code which creates an error:
LastRow = Master_Wksht.Range("N" & Rows.Count).End(xlup).Row
Is there a change between versions which means this line won't work any more?
That line is fine in E2007 provided you have 'SET' Master_Wksht but if you
hadn't done that it wouldn't have run in earlier versions of Excel
Set Master_Wksht = Sheets("Sheet1")
What have you dimmed LastRow as it should be long.
...Forms created in Word 2003 that I can't seem to edit in Word 2007
My IT department recently upgraded me to Office 2007. Much of it I
absolutely love. But it is taking some getting used to. Here is my issue.
I created many forms for my department at work in Word 2003 with form fields.
Now, when I open them I cannot access many of the functions on the "ribbon"
such as "Font", "Paragraph" etc. I have done quite a bit of searching
through forums online and not been able to solve the issue. I have found the
"Protect" tab and set it to unrestricted, but I'm at a loss at this point and
completely frus...outlook 2010.wrote in word works and saved can not open
saved work in beta2010 word work not able to open any suggestions
If you want to guarantee other programs can open the files created by the
beta, save as the old doc format.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
How many email accounts are in your main Outlook profile?
http:/...How do I convert numerical into words ?
I am using Excel 2000. In the excel I want to conver my numeric total amount
into words. Please help me.
"Kapil" <Kapil@discussions.microsoft.com> wrote in message
> Dear Sir,
> I am using Excel 2000. In the excel I want to conver my numeric total
> into words. Please help me.
(remove nothere from the email addr...Data Sort Unique
Excel 2010. I have 8 columns of data and I want a unique sort of all these
columns based on the 2nd column (name) i.e. After a unique sort, I only
want the first occurrence of the persons name. It is easy enough to do
with just one column, but the sort must carry all the other data with it.
wabbleknee formulated the question :
> Excel 2010. I have 8 columns of data and I want a unique sort of all these
> columns based on the 2nd column (name) i.e. After a unique sort, I only
> want the first occurrence of the persons name. It is easy enough to do with
> just ...How do I search specific words/phrases/terms in Outlook 2003's e-mails?
How do I search specific words/phrases/terms in Outlook 2003's e-mails?
For example, "apple juice". Another example, "base" and not baseball. I
tried using quotation marks like on Google, but that didn't seem to
work. I was unable to find anything about this in its help.
Thank you in advance. :)
Senior Software Quality Assurance Analyst
ISP/Symantec Online Services, Consumer Business Unit
Email: firstname.lastname@example.orgSYMC (remove SYMC to reply by e...Totally blank emails in Outlook 2007 03-12-10
I've searched and search for solutions to this issues but there is now
despite lots of people reporting the same.
Issue: I get totally blank emails sent to the junk mail of my Hotmail
folders in Outlook 2007. The only thing (and I mean ONLY) is a date and time
(no from, no to, no subject, no body text). If I delete them I get a whole
new batch the next day.
There was one suggestion that was too complex for me to do. I does not
efefct anything, it's simply annoying so I need a quick fix. PLEASE HELP,
Brian Tillman posted the following and it seems to have wo...Ignore word in downloaded transactions
In Money 2008, is there a setting that will cause "Checkcard" to be
automatically removed from every downloaded transaction? For
example, "Checkcard Starbucks" automatically changed to "Starbucks".
In microsoft.public.money, paul01463 wrote:
>In Money 2008, is there a setting that will cause "Checkcard" to be
>automatically removed from every downloaded transaction? For
>example, "Checkcard Starbucks" automatically changed to "Starbucks".
Banking->AccountTools->Categories&Payees->Payees->Preferred...Use XML Classes or DataSet to manage Data Records?
I am currently using native .net XML classes for managing my little
key/value data storage requirements and they work great. I have created a
simple class to abstract the XML and manage my key/value data requirements
that saves me tons of time and works great.
Now I need to use XML files to store and manage records as a flat file (no
relational data) and was wondering which path would be best. Do the native
..net classes make this kind of data manipultion easy (such as creating an
auto index field) or am I better of to read the XML file into a DataSet and
manipulate it from there.
If native ...Can Word highlight the passages that make the reading level higher
I have a document that is at a 16.0 level and it needs to be at 7 or 8. Can
Word hightlight the passages that are making the leve so high - so they can
...Is Out of office assistant available with std edition of 2007 offi
I am using office 2007 std edition. I cannot see the out of office assistant
option in tools please suggest whether this an issue with my office setup or
it is not available with std edition.
In article <C68FAF27-A9F0-4EF5-97F0-A945AF8A2357@microsoft.com>, =?Utf-
> I am using office 2007 std edition. I cannot see the out of office assistant
> option in tools please suggest whether this an issue with my office setup or
> it is not available with std edition.
You need Exchange Server for such functionalit...my word will not work as it does not have the right time zone???
just downloaded and word will not activate due to time zones and not been
able to verify date what can i do
Maybe review both Date/Time Settings & Regional Settings in Control Panel of
whatever version of Win you are using
"william" <email@example.com> wrote in message
> just downloaded and word will not activate due to time zones and not been
> able to verify date what can i do
...Trying to add resource allocation data to a gantt chart built in E
I'm using Excel 2003. I've been asked to create a one-page report that shows
major projects and work assignments, and their durations over a period of
time so we can see where they overlap and competing for resources. So I
created a gantt chart in Excel using the stacked horizontal bar chart feature
with the data as the task/start date/duration to create the bars (I got this
neat trick from this YouTube video, believe it or
Now, I need to overlay percentage of resource allocations for several teams
in different colors ...Cannot upgrade to Word 2007 from Word 2002 as word crashes when tr
We have a word add in that programatically inserts an auto text table then
adds rows to it. This works ok in Word 2002 but occasionally crashes in Word
2007 - this is not a consistent crash when we carry out the same operation it
happens in no specific sequence. The only place we are able to track it down
to is the auto text table inserting rows. Word itself is crashing.
We are using COM AddIn written in VB6.
Does anyone know of any key differences/issues between Word 2002 and Word
2007 that could cause such an error.
Or is there a better way to attach a debugger/word debugg...Opening Word doc with merge fields in Mac Office X
I'm trying to assist a user of Mac Office X open a file containing
merge fields. The problem is I have limited Mac Office experience and
I only have access to Mac Office 2004.
On Office 2004, when I attempt to open the file in question, I receive
a message that says:
"Filename" is a data merge main document. Word cannot find its data
One of the buttons in this dialog box is "Options..." By clicking
Options and then clicking "Remove Source" in the next dialog box, I can
open the file and modify it as needed.
The user...End of Word Document and Append from Excel VB
I am currently successfully moving data from Excel to Word and now want to
use Excel VB to append several word files together (created from Excel 2003
on Windows XP Pro). I have two questions related to this.
1) I want to know how to move the insert point to the end of the Word
document I open before I insert the next document. I recorded a macro in Word
and then tried:
But it didn't work. Does anyone know what will work? Please provide code
2) I then want to insert a Word document at this end point. From t...How do I create a Line Chart (Special)
I know how to create a line chart, what i want basically to do is create a
stack chart without showing the border or colour, all i want is to show the
line only ay the top of the stack.
hope this makes sense.
Stacked charts in general, and stacked line charts specifically, are not
very effective at showing information, but if you look at the other line
chart subtypes, the two in the center column of the Chart Type dialog (when
Line is selected in the list) are "stacked line" types, which only show the
line for the cumulative total at each catego...Word wrap #2
I have formatted a column to make sure that all of the cells wrap, but then I
noticed that the wrap feature of a cell supercedes that of a column. I
highlighted all of the cells and changed the wrap feature but the only way I
can get this to work is to do each cell individually. What am I doing wrong?
Also set the rows to AutoHeight.
Gord Dibben Excel MVP
On Fri, 6 May 2005 13:26:02 -0700, Joanne <Joanne@discussions.microsoft.com>
>I have formatted a column to make sure that all of the cells wrap, but then I
>noticed that the wrap feature of a cell superce...PowerPoint 2007 and relative movie paths
I am working on a support case with a client. She has been working in
PowerPoint 2007 with PPT file we built that goes along with a facilitation
system we sell. In the PPT file we’ve inserted WVM movies files using
relative paths. When she attempts to preview the movie the pop-up message
“Windows Media Player cannot fine the file” comes up. Typically this message
means the user has saved the PPT file in location that doesn’t match up with
the relative movie paths, but I’ve double and triple checked this; she has
saved the file in the correct location. What’s even more baffling, I...