Using Logical OR on text in Conditional Formatting
I have a column with various text entries. I have created a conditional formatting rule for each type of entry but the formatting can be grouped together, so I would like a Conditional Formatting rule that says:
If string contains "foo" or "bar" then colour red
If string does not contain "yibble" or "wibble" then make bold
Any idea how I can do this rather thasn having to manage over 30 rules with each one looking for a single text entry type.
Darius Try a formula of
=AND(A2<>"y...Color code quoted text
Is there no way to color code quoted text in the standard message
reading view? I've searched high and low and can't seem to find
anything about this.
The newsreader in Opera does a terrific job of this, as do many other
Yes, but since you decided to keep secret the version of Outlook you are =
using, all bets are off.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, rvgrahamsevatenein@sbcglobal...Y-Bars for Columns in a series
I have a chart (Column graph) that displays 4 means, 2 means (y-values) in
each of two series. I want to display a separate y-bar for each mean (with
1.96 times the standard error of the mean for each group in the series), but
Excel seems to designate a y-bar for the entire series only. When I set the
value for the y-bar. Is there any way to keep the chart displaying two series
with two means each and have y-bars that pull values separately for each bar?
I tried creating 4 separate series, but I lose the chance to label the two
groups on the x-axis.
You can put the va...Re: Writing a resume I'm not sure what I write in objectives #7
"GbH" <Geoff_Hannington@IEE.ORGasm> wrote in message news:...
> "GbH" <Geoff_Hannington@IEE.ORGasm> wrote in message news:...
>> "Ed Bennett" <email@example.com> wrote in message
>>> GbH wrote:
>>>> but neither is a resume!!!!
>>> So you're complaining about the lack of acute accents when people
>>> refer to a r�sum� as a resume? Why not correct to the intended word
>>> rather than a different one - pa...Ignore Y axis value
I have 4 facilities 901, 960, 972, and 990 that share 4 departments Pulling,
Shipping, Receiving, and Stocking that are graded on 4 criteria UPH,
Overtime%, IndirectLabor%, and Performance%.
I want a 1 bar graph for each department that compares each faclities
criteria in 4 sections. My problem is the UPH is in the thousands and the
Indirect is less than 10. So, in my graph I can not see the smaller numbers
in each sectioin.
Is there a way to have a bar graph that only shows the values on each bar
without regard to a Y axis?
That's called a table.
Jon Pel...I'm stuck...
can somebody please help me? I am trying to make a sheet whic
calculates how many production our machine can make in 8-hour shifts.
have the formulas to calculate how many minutes it takes us to mak
,for example, 80 tons of a product ,the change-over for the nex
product (and so on), but I cannot get it to split it up per shift:
-Mondaymorning 15 tons of product A
-monday afternoon 3 tons of product A &
12 tons of product B.
I hope somebody can help me.Using Visual basic is not a thing I am goo
at but I am afraid that is the only way to get it to work
-----------------------------...Display Y axes on both sides of chart?
Is there a way to display the scale for the Y axes on the left and the right
side of a chart?
You can specify second Y axis when you have two data series.
If you have only one, then make a copy in adjacent column (=B2 etc) and
chart his as second data series.
Come back if you need more details
remove CAPS in e-mail address
"Febra" <Febra@discussions.microsoft.com> wrote in message
> Is there a way to display the scale for the Y axes on ...Open XLS file without it's number format using VBA?
An XLS file has been saved with it's numbers formatted to a specified number of
decimal places. Using VBA how do you read in that XLS file with the numbers
unformatted and with the original number of decimal places?
Workbooks.Open (filename:="myFileName.xls", ????)
Not sure what you mean by "read in". The values are still in the cells. If you
open the workbook, then transfer the cell values from the worksheet to VBA,
you'll get the entire number, not the version that is rounded for viewing
On Wed, 06 Oct 2004 22:55:55 GMT, Dennis@NoSpam.com wrote:
>...How do I save the Page Setup settings for letterhead usage?
I have new company letterhead and have worked hard to set top, left, bottom
and right margins. How do I save those in Word 2003 so that if I'm printing
on this letterhead in future, I can just call up the format and create the
document without typing in all the measurements?
Save it as a template; see
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"NowWow" <NowWow@discussions.microsoft.com> wrote in message
news:0D892886-B419-4784-...Try this internet pack from M$ Corporation
Content-Type: multipart/related; boundary="yaprdlxknw";
Content-Type: multipart/alternative; boundary="tzoyybjqnb"
this is the latest version of security update, the
"November 2002, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to maintain the security of your computer.
This update includes ...Background Color
In my Publisher 2000, I made the background a color for my
brochure, however, when I print, the background color does
not cover the entire page. Please offer advice.
This is a limitation of your printer margins. Might try some colored paper instead.
Look at your printer documentation to determine your printer margins or open WordPad,
file, page setup, the default margins are usually there but if not input 0 into each
margin; it will then default.
Mary Sauer MS MVP
"Mark" <firstname.lastname@example.org> wrote in me...Conditional Formating and SetFocus Question
Thanks in advace. This place has answered a lot of questions before I needed
to ask. Now, I need to ask.
I have a Continous Form [DetailSubForm] based on table [DetailTbl] that has
the following fields. *[DetailID], [DocID], [CompDate],[SubDate],
[ConfirmDate], and [ExpireDate]. The [DocID] field is a dropdown list that
draws the data from the [TrainDocTbl].
I would like to use GetFocus to go to one of the Date fields depending on
the selection made in [DocID]. It would also be nice to be able to declare
the backcolor and forecolor of the whole record depending on that choice...I'm having problems inserting text files from notepad
When I try to insert a text file created in notepad, which contains
characters such as £, $ or letters with symbols over them, into a text box in
Publisher 2003 it comes up with a File Conversion window, and the options to
choose the Text encoding option. This didnt happen in our older version of
Publisher, on our old PCs. We have new PC running Windows XP and Office
Professional 2003 and I want to be able to insert the files without this
window appearing. I have checked the registry and CharacterSet value is set
to ANSI. Any suggestions on what is happening and how I can correct...0100 (24 hour) time
I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format
type that retains these numbers as four digits (allows me to go to 2400) .
Which format is it - I have tried several and it drops the first zero(0) off.
You need to custom format the col as: hh:mm
then enter the times with a colon, eg: 00:00
> I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format
> type that retains these numbers as four digits (allows me to go to 2400) ....Sort Column by Text Color or BackGrd Color
Does anyone have a method that allows you to sort by Text
Color or by Background Color?
Darn! It's so cold here in Massachussetts that my fingers hit the wrong key.
Check out Chip Pearson's page.
----- Ken Dickens wrote: -----
Does anyone have a method that allows you to sort by Text
Color or by Background Color?
The principle is to create a UDF to calculate the Colorindex and add it to
an adjacent column, and then sort by that column. Chip Pea...Cannot change criteria on copied chart without changing original c
I have a chart that I created from a pivot table. Instead of creating 40
plus charts individually, I tried to copy the original chart and change the
location for each chart. When I change the facility location for one chart
it changes all others. How can I get around this?
You'll need to make independent pivot tables for each chart.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
"Steve" <Steve@discussions.microsoft.com> wrote in message
news:07FF39D...Mark saved messages as sent
I have a rule that moves a copy of messages I send through my work
account to a work sent folder. But the messages show up there as
unread. I'd like to have the messages saved as read, but the only way
I can figure to do it is to manually right-click the folder, then
select mark all messages as read. Is there a better way? Thanks.
...Y axis labels in a bar chart
I'm trying to design a bar chart that will have the titles 'Low, Low/Medium,
Medium, Medium/High, High' up the Y axis instead of 1, 2, 3, 4, 5. I've
tried [=1] "Low"; [=2] "Low/Medium" etc but it will only allow 2 values.
Please help I need this by tomorrow. TIA
Try the Arbitrary Axis Scale example from my web site:
Jon Peltier, Microsoft Excel MVP
> I'm trying to design a bar chart ...Icon Colors
I just installed Office 2003 and I want to change the color of the icon that
> I am pointing to in Excel. In addition the color of the cell locator A, 1 for example
> is the same obnoxious orange color. Where do go to to change these colors
> without changing the XP color scheme (XP style, silver)?
You do not change these colors without changing the Windows color scheme or
Gord Dibben MS Excel MVP
On Sat, 7 Apr 2007 04:10:00 -0700, Dr. Kay <DrKay@discussions.microsoft.com>
> I just installed Office 2003 and I want to change the ...Money 2004: Can't balance savings account
I'm trying to balance my saving account in Money 2004. This is the first
this account. I fill in all the info such as statement date, ending
Then when I hit "next" nothing happens. The dialog stays up and I can't
The only way to get out is to hit "cancel" which of course doesn't balance
Anybody know what's going on?
...Contact View and Automatic Formatting
I have installed Outlook XP (Office XP have SP1 and SP2); I try to
personalize a View of Contact folder.
I want to use Automatic formatting and set this condition: "Message Class"
contains "IPM.Contact". It doesn't work!
When i used Office 2000 it work.. strange.. any helps??
...Open/Save screen settings
Hi, When I try to SAVE or OPEN the file, the screen is always default
in "LIST VIEW". How can I change the default in DETAIL VIEW?
Open 'My Computer' then set the view to Details. With it still open, choose
Tools and Folder Options, click the [View] tab and then the button that says
"Apply to All Folders".
> Hi, When I try to SAVE or OPEN the file, the screen is always default
> in "LIST VIEW". How can I change the default in DETAIL VIEW?
...Format this cell like that cell, automatically?
I keep my grades in an Excel workbook of four sheets, of which the
two relevant ones are Attendance and Grades. During the semester, if
a student drops the course I mark all cells for that student in both
worksheets as Locked and I apply a gray pattern to them.
Having to do this in two worksheets is kind of a nuisance. Is there
any way to set, say cells Grades!A11:AP11 to pick up automatically
any formatting and Lock/Unlock status as it changes in Attendance!A1?
I know I could do this in a macro, but I'm wondering if there's any
purely worksheet way to do it.
Stan Brown, O...#name? error after saving excel spreadsheet as web page
I have written an excel spreadsheet that takes advantage
of a fair number of excel functions.
When I save as a web page with interactivity, I am
getting #name? errors from a number of the functions in
the spreadsheet (including if statements and lookups).
I am using Excel 2002 on Windows XP with IE 6.0.
Any suggestions on how to fix this?
...Conditional formatting based on matching record in separate query
I would like to conditionally format a patient's name (e.g., Bold) in a
report, based on whether it finds that name in a separate query of New
Admissions. How can I make my condition look for matching data in the query?
The table name is Today'sList, and the query name is Admissions. The
matching field name containing the patient's name is "Field1". Do I need to
construct an expression using IIf (I'm assuming)? My question is, somehow I
need my conditional expression to say "If Field1 matches any record's Field1
in this other query (Admissions),...