Column A = Job Status
Column B = Date Completed
What I would like to have is if Column A = Done and Column B has no value, I
need to have a warning or a pop up of some kind stating that Column B needs
to have a date value when column A = Done.
Thank you in advance.
in a separate column?
(remove nothere from the email address if mailing direct)
"Michael S." <MichaelS@discussions.microsoft.com> wrote in message
news:BF4DD94D-F029-4F4A-A614-86F898E447E9@microsoft....changing contacts frm global address list to contacts in outlook 2003
This is a multi-part message in MIME format.
How do I change in outlook 2003 so that the first place when I address a =
email it looks at my contacts instead of my global address list. I'm =
using the office Microsoft exchange server version.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Trans...changing integers in a list
I have a list of integer numbers in a single column. They are in no
particular order, and I cannot sort them (it would upset the rest of the
spreadsheet). Some of the integers are repeated more than once, & I want to
increase the repeats by 1, then 2, 3 ... so that I end up with a list of
unique integers. So for example if I have 5,27,21,5,33,5,5 I would end up
I've been studying the Match, & other Lookup functions, but am unclear about
the best approach.
Hope this makes sense ?
You could try this:
(d...Conditional marker on subform?
I want to show an image if the record in the continuous subform is meets a
certain condition. When the records are shown on the Single Form there is
not a problem. But when shown in a continuous subform if the first record
meets the criteria all of the other records whether they meet the criteria or
not shows the image. If the first record does not meet the criteria and
other records do the image does not display.
I tried adding a field and inserting an attachment and as an OLE object but
this did not work and I could not update this field programmatically.
Besides I would ...How to generate a mailbox list file to use in scheduled ExMerge
Hi! Anyone know how I can generate a file that contains a list of mailboxes
to be used with scheduled ExMerge? I tried to interactively run ExMerge, then
cancell the program halfway, but it does not create the file I need.
An alternative for creating the file would be to use an LDAP query in a
script -- if anyone can help with that as well.
On Wed, 4 Jan 2006 11:05:04 -0800, MosesM
>Hi! Anyone know how I can generate a file that contains a list of mailboxes
>to be used with scheduled ExMerge? I tried to interactively ru...Excel 2002 mailing list in spreadsheet
I have a mailing list in a spreadsheet. Last name, first name and address
are in the first 3 columns, extra info is in the following columns - There
are multiple rows for each household. How can I delete duplicate rows
(names) so that I have a spreadsheet with one row for each household.
I assume the multiple households all have the same address.
Use Data>Filter>Advanced Filter on that selected column.
Check "unique records only" and "copy to new location".
For more on this, including copying the unique list to another sheet, see
Debra Dalgleish's ...Item posting account not defaulting on SOP invoice distributions
We are using GP 10 and am perplexed by the fact that I have set up SOP to use
posting accounts from the Item card and am not able to get these posting
accounts to default on the Sale Invoice when I change the value on one of the
segments. My posting account set up includes a Sales account, Inventor and
Inventory offset account and COGS account.
In a scenario where 01-4XXX represents a location and sales account on the
Item setup, the system defaults the account properly on the Sales invoice
distribution screen. However, when I create a different account with a sales
a...Sharepoint 2007 + Infopath 2007 + Webservice
I am developing a form with InfoPath 2007, accessing the web services of
their own SharePoint Server 2007 to store values in a custom list.
We use Visual Studio to program the button that will submit the information
in this form to the SharePoint list using the own web services of
We've mapped the values, but something goes wrong when our code tries to
access the WebService.
Apparently, and we've researched, is a problem of Credentials, but do not
know how to assign these credentials in our WebService object.
How ...Mailing List by Product
I'm trying to implement MS CRM 1.2 (spanish) in our office, and I have two
questions from my sales representative:
- How we can get a list of customers who have / haven't a one or variours of
your products? (It will be used to send mailings by e-mails or fax).
- We need to know if a customer belongs to an a Sales Group or Association
(sometimes, they buy products toguether to obtain best prices from us...). We
also meet with the people from a determinated group. How can we do it with
For the first question, you will probably need to build a custom rep...Opening a form from clicking on a List Box
Hi All, I had searched for some help on this issue and found it but I am
having an error and am requesting some assistance.
I have a form (frmMainMenu) that displays information in an Unbound List
Box. The List box displays the most recent entries in another table
(tblSENESarLog). What I want to do is to be able to click on one of the
entries and have that entry come up, in the Form (frmSENESarLog).
This is what I am using on my After Update event of my List Box:
Private Sub List235_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "...Conditional formating condition..?
I have 2 CF conditions associated with a cell (C14), one of which is:
Formula is =OR($C$4="Fred SOMEBODY",C14<>"10:30:00")
What happens when this is true isn't important/relevant.
The value in the cell appears as 10:30 (formatted as custom/hh:mm) but the
value in the 'formula window' is actually 10:30:00.
This type of condition works fine when the cell contains a simple number (or
text) but I can't get it to work for either times or dates.
I have tried it with and without the inverted commas (around the time value)
and have tried using 10:30 ...Combo box or list box
I can't figure out why the linked cell only returns a # value of the
selected cell in the range. I just wanted it to return the actual text
of the selection. I would think this would be the default, but I know
Please help this is really frustrating.
famdamly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29382
View this thread: http://www.excelforum.com/showthread.php?threadid=500004
Well, that's how they work! You can use a Match or Lookup formula to...drop down data want to choose more than one item for cell
I have a drop down box that i want folks to be able to choose more than one
item from the box to go into the cell.
Multiselect from a DV dropdown is possible using VBA.
See Debra Dalgleish's site for a downloadable sample workbook with event
Note that you can have the selections in an adjacent cell or in the same
Gord Dibben MS Excel MVP
On Fri, 26 Feb 2010 12:40:08 -0800, FranW <FranW@discussions.microsoft.com>
>I have a drop down box that i want folks to be able to choose more than...Conditional, Conditional Formatting
Two questions, both have to do with semi-complex (at least for me)
1) I have two conditional formatting "formulas" on column B. Depending on
the corresponding row in column I, I want the conditional formatting on or
off. If I3 = 0, then don't allow conditional formatting for b3.
2) I want cells from column A to be "strikethrough" if the corresponding
cell in column I equals zero.
Is there any semi easy (from a data entry standpoint) way for this to be
Say your current CF for column B is to...Create distribution list from names in To: field
How do I take a list of names in the To: field of an email and turn them into
a Distribution List. Using Office 2007. Thanks.
"esilverb" <email@example.com> wrote in message
> How do I take a list of names in the To: field of an email and turn them
> a Distribution List. Using Office 2007. Thanks.
...Excell conditional formatting
How do I make cell contents flash when they are outside a given value?
If you're kind to your users, you don't. Flashing cells are the spawn of
However, if you insist, I suppose you could find out how by searching
In article <39F93F7C-882D-4A33-82AF-65F1A80B596B@microsoft.com>,
"tab1701" <firstname.lastname@example.org> wrote:
> How do I make cell contents flash when they are outside a given value?
...Easy Question...Conditional formatting?
Hopefully this should be easy for all the experts...
Cells G4 thru R4 contain the text, "Act" or "For"
Cells G30 thru R30 are filled/shaded in red.
Cells G31 thru R30 are filled/shaded in red.
Cells G32 thru R32 are filled/shaded in red.
The cells which I have shader/filled in red....and with conditioning
formatting (or something else) I'd like to somehow referance cells G4 thru
R4 and if these cells contain "For" then leave the shaded as in. However if
these cells (G4 thru R4) contain the word "Act" I'd like to remove the
Operating System: Mac OS X 10.6 (Snow Leopard)
I am using Microsoft Office 2008 and I am trying to use the conditional formatting in a basic worksheet to display negative items with a different background color, but i can not seem to find the conditional format button anywhere. I am a very green mac user, so someone please help?
But Format>Cells>Number gives you the opportunity to turn negative numbers
red, which may be simpler than setting up a conditional format.
On 19/03/10 8:38 AM, in article 59bb57fc.-1@webcr...microsoft project 98 and windows xp home edition
Can Project 98 be successfully installed and run with
windows xp home edition? If not, what about project
Thanks for your help.
Why not ask the windows xp newsgroup instead of the Microsoft CRM ng?
Office Equipment & Supplies at http://www.presentationsdirect.com
"luke rose" <email@example.com> wrote in message
> Can Project 98 be successfully installed and run with
> windows xp home edition? If not, what about project
> Thanks for your help.
...Weighted items #2
I'm working with a client who runs a small chain of meat markets and I am
finding the problem that at our POS the scale can only weight 30 pounds and
we sell boxes or big packages of some products over this amount. So here is
the question, is there any way that I could bypass the scale so that the
weight is manually introduced at the POS?, I would really appreciate your
...More that 3 conditions for conditional formating?
How do I set more that 3. I need 6 or 8.
I want to have color of cell change if one of the 6 or 8 words appears in
limit is 3. You can, however, check for the appearance of the word by some
where F1:F8 contains the list of 8 words and A1 is the active cell. If it's
not an error, the word exists, and you can make the cell be whatever color
you want. You just can't have 8 different colors.
"Jerry Kinder" <firstname.lastname@example.org> wrote in message
news:eefsibF1FHA.664@tk2msftngp13...Budget Items do not appear in Monthly Budget Report
I've been using Money for nearly a decade to track account details and that
has worked fine. Now, I've decided to start using the budgeting
functionality and am extremely frustrated. I have items that show in the
budget, but when I view the Monthly Budget report they are not included.
What gives? The item is a simple mortgage payment setup as a "Loan Payment"
bill from checking to the mortgage loan account. Please help!
"R. Ian Lee" <RIanLee@discussions.microsoft.com> wrote in message
news:C07484ED-52E3-4FA8-87EF-EB0679821972@...Stored procedure- XML
I've created a stored procedure to accept XML as parameter
and loads the apporpiated field in the tables in SQL 2000.
Evenrything works except.. the following
I would like to update existing record if the ID exists in
the table, otherwise insert the record(node) into the
I couldn't figure it out how to do this... using the XML
...List of pointers to XML nodes
I have an XML file which its content can't be altered as a source. My
solution should be able to produce some kind of pointers (in a seperate file)
to specific nodes (or even attributes\values) in the source XML file.
The source file contains many different namespaces (along with defaults).
The output file later will need to be processed and rewrite sections of the
XML source file by using the pointers ...
What do you think is the best approach for this problem? one solution is to
create a file containing a list of XPath queries - The problem is that XPath
in its nature ca...help with Conditional formatting pairs of cells
I have a spreadsheet which is laid out as a burial ground map showing who is
buried where and whether a headstone is in place.
2 cells represent one grave as there may be 2 people buried there.
The format has 4 conditions:
The sheet has 10 columns of around 20 pairs of cells.
Conditional format over the whole range works fine when the pair of cells
for a grave are marked empty or where both cells are used (for 2 people in a
My problem is finding an easy way to conditionally format the second cell of
each pair to match the ...