=IF(SUM(K9:K34)<K4*COUNT(K9:K34)*($AJ3),K2,"")
cell K2 has been formatted so the text is blue, how do i get the cell to
format itself blue, should the "if" statement be true, in such a way that
only changing the formatting in cell K2 would change the formatting in this

I am trying to email a single Excel worksheet.  I have found how to email an
entire workbook.  I was able to email a single worksheet in Excel 2003, I am
hoping that the same function is available in 2007.

This may be really stupid questions but here it goes...
Below is my formula,  I am adding some columns then dividing by 3.  Next
week I will need the same columns added but will need to divide by 4, the
follwing week by 5.  Is there any way Excel will do this without me manually

could someone please help me with a formula to change a number (such as a
date) in a text string in the next cell:
for example:
in column A I have data that reads:

Greetings. I am trying to add multiple values in one column based on
multiple values of the same value (text) in another column. A little
simpler said . . . in column B I have a list of usernames. In column D
I have number values (a number showing how many times that person made

I have been making extensive use of this feature when using Excel pivot
tables to analyze data and send out to the relevent staff member. As far as I
can see this option has been removed from 2007. Can it please be put back in
as it is a lot simpler than using cut and paste ...

I have an excel sheet that lists members of a department. Next to their name
in column B they need to put yes, no or maybe. As they type their answer I
would like yes to be red, no to go blue and maybe to go green. Can you format
cells based on what answer they put in the cell? ...

I have updated the jTWSdump web-page with new information and
examples.
http://home.cidadevirtual.pt/jtwsdump/
jTWSdump allows to download historical data from Interactive Brokers

I can open Excel 2003, and from there retrieve the various excel files that
I have already created.
For some reason, I can no longer go directly to the file through my
workbook, or directories, and double click on the excel file, and get them

I have a graph that i have created and i assume there is a macro out there
for it somewhere.  What i would like to do is find that macro, name it,
create a button, and then assign that macro to a button.  I'm trying to avoid
having to recreate the graph while recording.  Is there ...

MS OS: XP
Excel 2000
I keep my Excel program minimized.  When a cell or range of cells changes in
sheet2 I want the Excel program to maximized and make a sound.

Is there a way to sort worksheet tabs in a group?
i.e. - numeric by worksheet # 1, 2, 3, etc . . .?

I have a speadsheet that indexes all appointment letters.  Each title is
hyperlinked to the file with the same title, so that when it needs to be
updated it is readily available.  Most are Word documents, a few are pdf
files (which aren't editable like documents) and one it an ...

I was given a worksheet from our budget office to calculate COLA and merit
raises.  There are formulas in the cells to perform the calculations  but
when I enter the increases the cell which has the formula in does not update
the current amount.  If I double click on the cell it ...

Am an excel novice to say the least and am looking for some help.  I want to
take a document from a web page into excel.  The document updates itself
daily, i would like the excel copy that i have saved to update with the
information from the webpage. I have tried the Get ...