conditional format formula
I am trying to use a formula in conditional format to turn a cell grey if the
date in the column is not yet passed.
not colored not colored
should be grey
=IF(NOW()<a$2,,) Is my formula. Whether I use < or > does not matter, th...Conditional formatting with dates formula problem.
I appreciate help on this topic. I'm very new to excel's conditional
formatting capabilities and I need help on the following:
I have a worksheet where I am using columns A and B to be fashioned
into a type of "reverse" library checkout card; I want to flag when 120
days have passed since an item has been checked out. All cells are
blank with the exception of the formatting applied to cells in column
A. For example, Condition 1 on cell A1 has the formula:
**I've also tried =IF(ISBLANK($B1),($A1-TODAY())<120)
My objecti...Count unique names in a list
How do I count a list of names, some names appear more than once. I only
want to count unique names.
I use excel 2007
Microsoft Excel MVP
"Cassie" <Cassie@discussions.microsoft.com> wrote in message
> How do I count a list of names, some names appear more than once. I only
> want to count unique names.
> I use excel 2007
For ...Formula to eliminate zeros
I have a column of values that is 200 rows tall. The values are eithe
a five digit option number or a zero. (I can change the formula tha
generates this column to put anything in place of the zeros of tha
helps) I need to transfer those option numbers to Work Order in
concise list without 175 to 200 zeros. I need to do this automaticall
with a formula when the data is imported so my purchasing dept. doe
not have to filter the numerous lists with each job with a drop dow
menu. I could have all of the zeros on the bottom if I can get all o
the five digit option numbers to appear at the top...array formulas-sumproduct and average
Hello, I need hel. I am using this formula
=SUMPRODUCT(--(E2:E289=1),--(AVERAGE (H2:H289))) I don't know what's wrong
with it. I need to find the average for column H in relation to 1(under 2
yrs) in Column E. Hope this makes sense.
Array-enter the formula with CTRL+SHIFT+ENTER
GMT+8, 1� 22' N 103� 45' E
"Becky" <Becky@discussions.microsoft.com> wrote in message
> Hell...Formula for file location
Hi (I'm a newbie so please be patient)
I am using excel to build a database for an online store, i have apro
3000 products and each product needs an image path (eg. D:/m
I need a formula that will automatically insert the path to the image
in its cell in the image colomn.
To make this easier all the image names are the the part number[.gif
so the image for product 123 is D:/my docs/images.123.gif.
Can any one offer a formula to do this?
Example of spread sheet
Make Model ...File names
How do I remove changed (no longer relevant) file names
from my File list?
You can go to Tools--Options and specify the Recently Used File List as 1
(minimum). Press OK and this will then then clear it out so that only the
last file opened is in there.
Go back to Tools--Options and change that number back to whatever you'd like
it to be, for example 4.
This will then make it repopulate that list as you open files, up to the
number that you specified, in this example 4.
"Robert W." <firstname.lastname@example.org> wrote in message
news:017f01c39806...Multicurrency activation and Project accounting
I am about to turn on MC where project accounting is running -- the database
has 10 years of data. Does any one know how long running check links will
AND, will all Projects read as the functional currency following this? I am
very concerned about making this change and would like to hear the good and
bad if anyone has done it before. Thanks!
I would recommend setting up a test server and testing all changes
completely. It is a good idea to involve the users in the testing.
It is very important to test all changes in GP before applying them to a
prod...copying formula down
Using Excel 2003
Column A is dates. These dates plus 7 are being compared to the current
date to determine whether "overdue" gets displayed in Column D. I'm using
the following IF statement:
If A1+7<today(),"overdue"," "
When I copy the formula down, rows that have not yet had data entered into
them are all displaying "overdue" because Column A is blank. Do I just need
to remember to copy the formula down every time I enter a new row of data,
or is there some way I can modify my IF statement to only do the calculation
if there is data ...Break up a name
I ahve a list of names, with middle initials, that I need to break up. For
example the names are formatted like the following:
Bayer, Daniel E.
I need help with three results: the fist is the first name only; the second
is the last name only. And the third, I know I can merge the results for the
first and last name, but if there is a formula that will bring out the first
and last together I would love to learn what that formula is.
Thanks for the help.
Text to columns, separate on the comma. then text to columns separate on
> Hel...Cant get "Platform Builder" to appear under "Project Types" in VS2005
We've just purchased PB 6 and am trying to install it on one of our
development stations, but no matter how many times I've installed/
deleted/reinstalled VS2005 and WinCE 6 I cannot for the life of me get
it to appear in the project types list for when creating a new
solution. It wont even allow me to open an existing project from the
demo WinCE 6 folder. I'm now in to my 3rd day of battling with this !
Though the PB icon shows on the splash screen as it starts, as does
some of the CE6 'getting started' stuff on the start page.
It has had the ...Can I combine a Vlookup with an IF formula?
I'm not sure Excel can do what I want it to do -
I have a VLookup formula on my spreadsheet which is returning data, however,
I only want it displayed if it returns a specific condition.
Is this possible ?
let' say you want to perform the vlookup if cell A1 is greater than 100, if
not will leave the cell blank
> I'm not sure Excel can do what I want it to do -
> I have a VLookup formula on my spreadsheet which is returning data, however,
> I only want it disp...Replacing a subdirectory name in a macro
I am currently running a macro that every time I run the macro I have t
replace the name of a subdirectory that a file is saving to. Is ther
anyway I can name a cell in ecel that has the subdiectory's name store
in it, and get the macro to accept that name in the address that th
file is being saved to
Message posted from http://www.ExcelForum.com
Dim TodaysFolder as String
TodaysFolder=cells(1,1).value 'cell A1. You should add the workbook & sheet
names to make 'sure it's the right one
ThisWorkbook.SaveAs "c:\thisfolder\andthatfloder\" & TodaysFolde...Remembering User name and Domain when logging on
I have setup outlook users that log onto domain A but take
their user accounts and exchange server from Domain B.
The users log into windows and when they load outlook are
prompted for a user name, domain and password. (created in
services/exchange server and turning of security)
Problem is half of the machines dont remember the user
name and domain, and the other half do!
its not a version problem cos it happens with 97.04, 97.02
I would perfair all users to just have to enter a password
can anyone help?
...POP3 server names
where do i find the outgoing and incoming server names to set up an e-mail
From your ISP.
Windows Mail: Setting up an account from start to finish
Imperial Beach, CA
"lisa law" <email@example.com> wrote in message
> where do i find the outgoing and incoming server names to set up an
> e-mail account?
You get the correct ma...How to write multiple Name space
Can someone show me how to write the following fragment out, using
<Message key="comp" xmlns="http://www.xxx.com"
Phil Hunt wrote:
> Can someone show me how to write the following fragment out, using
> xmlwriter. Thanks
> <Message key="comp" xmlns="http://www.xxx.com"
Write the 'Message' element in its namespace 'http://www.xxx.com', then
write tw...Addition Formula #3
What type of formula do I need to have a column total values in a row if the
cells in the rows value is less then a value in a certain cell?
Row 2 one has dates in it ( 10-1, 10-2, 10-3, & so on)
Cell A1 has today’s date in it =TODAY ()
So I want Cell J3 to date the values in the cells A3 thru I3 of row 3 if the
date above them in row 2 is less then Cell A1- today’s date.
...saving with name from cell #3
That one works perfectly!!
Dank u de veer!!
jamaz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1663
View this thread: http://www.excelforum.com/showthread.php?threadid=31504
You are welcome
Regards Ron de Bruin
"jamaz" <firstname.lastname@example.org> wrote in message news:email@example.com...
> That one works perfectly!!
> Thanks again!
> Dank u de veer!!
>...Project Server and DNS
Has anyone ever had a Project Server create an second DNS record for a different Computer name associated with the same IP address? I know this is a really strange question, but somehow it actually happened. I am not the Network admin and he swears he did not do it.....
Any thoughts? Anyone?
EggHeadCafe - Software Developer Portal of Choice
C# Email With Attachment / Upload / Validation
Project Server gets blamed for a lot of things, but I suspect it's not...Array Formula Help -IF / Else clause?
I'm just getting to grips with Array formulae, and one of the formula I
use most frequently is to count combinations of values over two arrays:
To give a count of all the Ford Focus in a 2 column list/array (Make &
Model in columns A and B respectively)
I understand how it works. Creates (and sums) an array of 1s for every
combination where there is Ford & Focus.
But what I don't understand is how the second IF fits in.
Isn't the second IF basically the ELSE clause of the first IF...If formula?
I am not sure if I need an IF formula but I am preparing a spreadsheet
for work and basically it's a sponsorship form and if the person gets
sponsorships of different levels they get a different prize i.e.
Up to �10 - Wallet
etc up to �60 and I would like to enter the amount in column B and
then then let the computer to enter either the prize in column C.
Can anyone tell me how to do this.
I am totally new to excel.
One way is to use VLOOKUP. First create a table of information:
40 ....Can I change line numer or column name
I'd like to change my line numbers to specific salespeople and column names
to specific months. Does anyone know if thats possible and how to do it?
Dave, you can't change the ones in excel but you can put your own in row 1
and column A, then you can hide the row and column headers if you want,
tools options, view, uncheck row and column headers
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Dave Bonneville&q...Display Name that E-Mail Recipients See
re: Outlook 2003
When I send e-mail to people, in the FROM FIELD, they only see my
complete e-mail address. The e-mail address is NOT preceeded by a
"friendly" display name, as one might expect.
As per MS Office Online Assistance at
I have ensured that I have the friendly name I want showing in the YOUR
NAME field under USER INFORMATION under TOOLS|E-MAIL ACCOUNTS. This
does not solve the problem.
I can temporarily solve it, per individual e-mail message, by selecting
HAVE REPLIES SENT TO under MESSAGE OPTIONS a...How do I put a unique logo into Personal Info set on MS PUB
I want to get my own unique logo. THEN I want to put it permanently into the
"logo" box in the Personal Information area so that I can frequently use it.
Is this doable?
Lots of help here
Edit a logo for a personal information set
Mary Sauer MSFT MVP
"Gil Fair" <firstname.lastname@example.org> wrote in message
>I want to get my own ...Project table schema changes in 9.0
I upgraded a server from GP 8.0 sp5 to GP 9.0 sp2 last weekend. All seems to
work fine so far.
I have some Crystal Reports that were in the process of being developed and
I have questions about 3 Project tables. These tables each have had fields
My question is...Where has the data these fields represented been relocated?
Has the upgrade taken data from these tables and moved it to other tables?
*** Lists the fields added and removed in Project tables ***
C:\Program Files\Microsoft Dynamics\GP 9.0