I am wanting to find out if the NOW() function can be updated automatically
every 30 minutes - i have a formula which changes a date to tomorrows if it
is after 5pm - but the now function obviously doesn't update automatically.
Can any bodyhelp?

Excel 2007- How can I get the font color to change automatically to red when
I am using the Percentage Format in Cells and the answer is a negative
number?  The dollar format works perfect but there is no option in the
percentage format to allow this to happen.  I assume I have ...

Is there anyway I can use information on an excel worksheet to create
multiple files? I have data on say 'Tab1'. I have subtotalled data by cost
centers. Can I get a new file created in excel for each cost center ? Can I
have a naming sequence assigned to this?

I received a worksheet with preset sorts for each column (each has a
ascending/descending arrow).  How do you do that?  I have looked everywhere
and can't find anything that even talks about this.  Then again, it may be I
don't know what this is called.

I have checkboxes on my worksheet that need to be grouped together. If there
are 2 or more checkboxes  I only want 1 of them to be checked, and the
other(s) to be unchecked.. In other words if 1 checkbox value is true, I want
the others in the group to be false.

When creating a link to a cell in another workbook, I want to make the query
dependent on the contents of a cell in the destination worksheet.  For
example, I want to specify the path, the tab and the workbook in cells and
create references to these cells in the external link.  ...

I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in a
second cell, but when inserted into the second formula, I want the 0.25 to be
"converted" to 0.9. I don't want to change the ...

I hope someone will be able to help me.  I have tried a number of things but
can't get this just right.  I want to be ale to make the text in a cell turn
red if todays date is between two dates.  Example:  in Cells A1 through A12
are the months of the year (January, February, ...

I have a workbook with multiple sheets, each sheet in column (A) has a three
digit number that is assigned for a piece of work. Column (B) will describe
the vehicle used for that piece of work. the purpose of these sheets is to
track the time of the piece of work, at a location. ...

I have a worksheet that looks like this:
A                       B        C        D       E       F      G    
..............................
Date                 ---      Line    ---      ---     ---     Value

I'm a little stuck.  I have a table with gene names as column headers and
patient samples as the row headers.  In our lab testing, each patient sample
will have at least one (many times more) genes that have a numerical value
associated with it.  For example, sample A987 may have ...

Is ther anyway to combine the now and today fuctions in a logic formula?
Somehting like....
if it from 7am to 11:59pm then display today and if it between 12am and 7am
display yesterdays date

I have two (A&B) columns with dates in each
I them have (C) with the formula =DATEDIF(A6,B6,"y") & " years, " &
DATEDIF(A6,B6,"ym") & " months, " & DATEDIF(A6,B6,"md") & " days"
I need to total column (C)

I need to compute the number of years, months and days between dates.  After
doing so:  if days >= 15 then add 1 to month and days becomes 0, then if
months > 9 add 1 to year and then months becomes 0.
I will need to do this for several rows and them sum up the individual columns

Hi, I am using Excel MSOffice Xp (2002) and would appreciate help with the
"if" function. I am trying to create a Retirement formula and running into
all sorts of errors and will try and explain the scenario.
In the most simple context, I am basically trying to create a formula ...