Does anyone know if it is possible to change the text color when usin
an IF statement? Example:  IF (C<4, "Pass","Fail") results in "Pass
for values less than 4, but if the value is greater than 4 I want th
word "Fail" tp appear in red.

I have 1/4/04 in column A1. I want to write a formula in
Column B1 to add one month to the date in A1. In A2 I want
to add a year to A1. Result would show: B1=1/5/04 and
A2=1/4/05. How do I do this?

Is it possible? I have a spreadsheet with one column in it in which the
values may range between several thousand and several trillion. (These are
money values so scientific notation is not an option.) The values in that
column are all calculated on the basis of values in other ...

When I pull data from an external data source, the values which appear in
the cells under the row fields are truncated, eg an account number which
should be 0000001 appears as 00000. This then causes the data to come out
all wrong. I also have the same problem with a pure text ...

I keep having the same problem over and over and I can't seem to fix it.
I have a sheet with 47 rows of data in it.  For some reason it puts 8187
rows in the sheet.  Sometimes it makes the sheet 65,000 rows long.  This is
causing my file sizes to be extremely large.  I need a fix.

I am working in to seperate work books(call them wrk1 and wrk2), I a
wanting to reference back to wrk1, say cell J2. If the value is 0 o
larger I want to add 1 to it number from the wrk1 to give a runnin
total in wrk2.

I got an e-mail in Outlook from someone and it is supposed to have an
attachement of something in Excel, but I don't see the attachment anywhere
in the Outlook window, and I don't even know where to find the attachment to
open it.

Can anyone help
could someone please scroll down a few lines to "trouble with an if stmt"?  I have further ?'s and I didnt think anyone would look at an old posting and didnt want to re-type all the info.  Please read all comments.

I am trying to develop an order form to be used in our
office by our employees.  I'd like to be able to have
each invoice have a new, consecutive number - done
automatically!  Is it possible and if so, how.  Thanks

Help is needed !
I have to create a database in Excel of people that will look like:
A    B        C        D
NAME,    ADDRESS,        DATE OF BIRTH,            TELEPHONE NO.

Need to know if there is a way to line up cells based on data. e.g in column
A I have numbers 1200 through 1300 and the numbers can repeat themselves
many of times, this is why sorting will not work. In column B I have the
same numbers but in my case I could be missing some ...

I need know if variable contents space, for example:
myvar = "da tas"
if myvar (contens space) then ....
Thanks Tom

HI, Please help
I use vlookup, but it return a "#N/A", please show me how to make it be zero, because I
want to use it to plus a cell
Thanks in advance

Dear NG,
What should be the formula in custom data validation so that when A1 is
empty no entry will be accepted in A2?   Please no VB!
Regards,

In English Windows the seperator for a formula is comma ",". For Italian it
is the semi-colon (;).How can this be automated or detected using VBA.
Any help would be welcome.