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...Name cells before sort
I've a long list of clients, all with values. I have to count and sum them
all but first i have to name them all. I'd like, if possible, to do a sort
first and name it all and then put the list back how it was, but i loose the
reference of the names. Any ideas?
Tks in advance
Try using a pivot table to summarize your data. For more help see:
thanks for the explanation.
i just have a couple of more questions about what you mentioned.
in effect, until i have a number that is 4 digits or longer, there wil
always be a null padding around the number if i use long. is tha
correct? in which case, can i presume that if the number is less than
digits long when the variable is declared as 'long', i will always hav
to use trim? or is there a way to circumvent it, that is, carry o
without having to using trim and cstr (i had also tried cstr whil
-------------------------------...view cell content in header
Can I customise the header so the left section = the content of a cell
in the sheet eg A1.
All I seem to be able to do is add date, page etc etc..
Images of home (NZ)
What we are up to in the UK
You need some VBA code to do this:
You can use the workbook_beforeprint event to modify the header.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.PageSetup.LeftHeader = .Range("a1").Text
This goes behind the ThisW...Click Entering Absolute Cell References into a Formula
When one is in the process entering a formula into an
EXCEL spreadsheet it is possible to click on another cell
to automatically have this cell reference placed into the
formula. However this entry always is entered as a
RELATIVE cell reference. Is there a way to have EXCEL
insert an ABSOLUTE cell reference into the formula??
It seems to me that it would be so common and yet I have
never been able to figure this one out.
Is this what you want?
Click the cell and then press F4.
F4 acts as a toggle going through the four reference options.
...All formatting not saving in Chart Template 04-07-10
Hi, sorry if this has been answered. I am new to Chart templates. I created
a pivot chart and saved it as a template. When I bring it back up again, not
all of the formatting is saved. For example, the title is just "Title" and I
had data values being shown and they are not, and also the colors of the
columns are not the same. Is there any way to save all of these as part of a
...number format in excel
I have an issue with excel 2003 running on one of my laptop. The integer
number i input in every cell will be divided by 1000, for example when I
input 123 the cell will show 0.123, however if I input 123.00 it will show
just as 123. Also if I copy the excel file to other computers everything
looks ok. There is no cell format defined. It looks like an global setting
in excel because either old excel file or new created excel file all have
the same issue.
Anyone can help?
From the Menu Bar:
<Tools> <Options> <Edit> tab,
and *uncheck* "Fixed Decimal Places"...Formatting Subject Line in Red Font
I have seen e-mails that people send to me that have the to line and subject
line in the e-mail in red font when I receive it. How is this done? I use
both Outlook 2000.
Hope I explained that well enough.
-- All Outgoing Mail Scanned for Viruses --
What mail client are they using? Right click on the message and select
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.group...CFileDialog question #4
How do I set initial file selection after the construction. In other
words, can't use m_ofn....
Any idea, anyone?
<firstname.lastname@example.org> wrote in message
> How do I set initial file selection after the construction. In other
> words, can't use m_ofn....
What makes you think that? Just set dlg.m_ofn.lpstrFile = filename before
I realized my question was not very clear.
I have a class CMyDialog derived from CFileDialog. I need to set the
initial selected file inside CMyDialog code,...CRM 4 & AVAYA IP Office Integration
I currently use CRM 3 with the Avaya IP office integration piece. I read in
this forum that that interface does not work in 4.0. Does anyone know if it
truly does not work or if it's just not "supported"
Yes, looks like it is not available as of date. Check out this IP Office
Technical Tip 203, 4/21/08:
No ETA date mentioned, I would check with your IP Office Partner.
Frank Lee, Microsoft Dynamics CRM MVP
http://www.work...Stock Symbols #4
Using Money 2002. I have several accounts that use the same stock symbol and
when I try to add an account to the portfolio I get an error message that
says, "that symbol is in use by another account". Is there anyway of adding
the other accounts?
In microsoft.public.money, Neil Harrer wrote:
>Using Money 2002. I have several accounts that use the same stock symbol and
>when I try to add an account to the portfolio I get an error message that
>says, "that symbol is in use by another account". Is there anyway of adding
>the other accounts?
You got a m...count cell with background color 36
First I want to count the number of cells in a range that have text in them.
Then I want to count how many of these cells have the back ground color 36
This will achieve what you want for a continuous range, Column A in
this example. Change the variables to suit.
Dim lw As Integer
Dim counter As Integer
Dim MyConstant As Integer
Dim i As Integer
lw = Range("A" & Rows.Count).End(xlUp).Row
counter = 0
MyConstant = Range("A2" & lw).SpecialCells(xlCellTypeConstants).Count
MsgBox "The...Named range(s) of non-adjacent cells return #VALUE! error in array formulas
I have ranges made up of non-adjacent cells from one worksheet and I
get a #VALUE! error when I try to do any conditional count or sum
calculation with an array formula on either or both of them. Each
range is a selection of 32 non-adjacent cells from a single column.
The cells contain array formulas that return percentages.
Example of range values
I was able to get values returned from simple functions like Max and
Min but the following example gives me the #VALUE! error:
Any wisdom ...Cell Reference Formula Outside Workbook
I am trying to reference a cell outside of my current spread sheet. I
am using a cell in my current sheet as an input for the extension of
the file I would like to look in. So I have this defined as LINK. And
the value of link is something like C:\\Myfolder\ready.xls
I am trying to set up a formula in my sheet that will use this
reference to the cell on the first page, which I defined as LINK so
when I change the value of the cell all my values will update to the
new folder and document, but retain their previous page, column and row
For example. My current formula reads
[...SQL Replication with CRM 3.0 and 4.0
Is SQL Replication possible with CRM? Are there any documentation available
Thanks in advance
...Lost Format Painter in Outlook 2003
I have been everywhere, and the Format Painter toolbar which was there in
Outlook, is gone. I've checked and clicked everything I can find for 2 days.
Can anyone give me specific directions ? My version of Outlook, when I
click about MS Outlook, shows SP1.
My laptop is my only computer, and it is brand new, and uses WinXP.
I've put in this question to help at the upper right of the Outlook screen
in 10 different ways, and it simply doesn't have an answer to this question.
I've been through this in the past, and someone else fixed it, so I do not
know how to do it...Test for validation list in a cell
I have tried to post this for ages now in programming. But it does not show
up - apologies if this is the wrong group.
How do I check for a validation InCellDropDown list in a range
If Range("C30:K30,C36:K36") 'has validation' Then
This looks at each cell to see if it has .incelldropdown.
Dim myRng As Range
Dim myCell As Range
Dim AtLeastOneHasInCellDropDown As Boolean
Set myRng = .Range("C30:K30,C3...Memory leaks #4
When I exit from my application I see this message:
Warning: destroying CSingleDocTemplate with live document.
Detected memory leaks!
Dumping objects -> .............
What is this message?
I have seen that my application really have a memory leaks.
How can I avoid this memory leaks?
pair the memory allocation with deallocation.
"john wayne" <email@example.com> wrote in message
> When I exit from my applica...Multiple functions in a cell help
I am using Excel 2003 and having trouble figuring out the formulas. What I am
trying to do is add a total of 6 cells in a row. Each cell has a different
formula that comes up with a certain value once all cells are added together.
cell A= inserted value*10
cell B= inserted value*2
cell C= inserted value
cell D= inserted value*5
cell E= inserted value*3
cell F=inserted value/20
In cell G, I want to add cells a through f except that cell f has multiple
&quo...save as a cell VBA
Good afternoon Group,
Would somebody please tell me the VBA to :
Copy the worksheet to a new book -by creating it-
then save it as the cell "B1"
All assitance on this subject will greatly help me with my daily labors,
Thanks in advance and greetings
I just recorded this. See cleaned up below
' Macro11 Macro
' Macro recorded 8/28/2008 by Donald B. Guillett
ActiveWorkbook.SaveAs Filename:="C:\files\mynewBook.xls...create a thin border around the selected cells
need information on excel 2003
on the Menu bar choose FORMAT | CELL | BORD
regards from Brazil
"Chandra Lee" escreveu:
> need information on excel 2003
Hi, I want to enter a date into 1 field (a) and change font and colour
in another field (b) but still retain the data that is in field b. Can
you help. Thanks
Use the AfterUpdate event to change the font and color. Something like:
If Len(Me.txtControlA & vbNullString) > 0 Then
Me.txtControlB.FontBold = True
Me.txtControlB.ForeColor = vbRed
Me.txtControlB.FontBold = False
Me.txtControlB.ForeColor = vbBlack
Arvin Meyer, MCP, MVP
http://www....Color format not saved in MS Project 2007
A PM reported that color format used in his project files disappeared from
project server after it's level loaded against other projects in the server.
Is this an error? This seems to happen when you select color formatting from
the Gantt view.
Not exactly sure how it works but from what I gather if you have a view
definition contained in the global enterprise then customisations to view by
the PM (incl. colouring of tasks or font changes) will/could be overwritten
by the PServer definition in the global. you can make it work but got to
fiddle a bit with view/organiser stu...Locate and Move specific cells
I have several cells randomly located on a worksheet , each containing a specific word. I need to copy these cells to a new worksheet starting in column A, vertically.
I have used the "Find/Replace" command to locate the cells, but I don't know how to copy them to new sheet.
I'd really appreciate any ideas.
What do you mean by move?
Clear the contents of that original cell
delete the cell and move the rows up?
delete the cell and move the columns to the left?
delete the whole column or row?
I'm guessing that you meant to clear contents.
This might work for ...Formatting Imported Data
I want to be able to read in a single column of data from either an
Excel file or from a column of a word document and then produce the
same column of data so that each entry has two cells separating them.
So that the column
would look like
I there a straightforward way I can do this in Excel w/o having to use
some type of additional program (like VBA)?
Nothing straightforward that I can see.
Without some manual arranging which would be onerous, you will be better off to
use a VBA macro.