i want to create a conditional format/formula that will do the following
if cell <2 then colour green or if same cell is >=2 or <15 then colour
yellow or if same cell is >=15 then colour red

please help

Lately, I am unable to display, when entering edit mode in a cell, the
cell's formula-referenced cells. I used to, upon pressing F2, see a
cell's formula and, highlighted in differing colors, the cells
referenced by the formula to be edited/viewed.

Hope someone here can help...
I hav an excel file with a vy big file size which i believe is out of
the fact that there are many "blank" cells/rolls/columns
Can someone tell me how to delete them in an effective way?

Do know how I can re-use an Excel macro. For example, I have imported a tab
delimited ASCII file into Excel and recorded the process in a macro. Is it
possible to use that macro to import other tab delimited ASCII files(so open
the macro and open another file using the macro ...

This seems like a simple scenario although to get it to work on excel seems
impossible.
Here goes.. i would like to set up a spread sheet whereby i could type in
the various forecasts sales for the week from cells A1 to A7 say. I would

I'm trying to use an existing drop list (containing an "if" statement) to
change an area on the spreadsheet designated for graphics.  The idea is to
change logos as each selection from the drop down changes.  Is there a way to
do this without changing or refering to an entirely ...

how do you use thw ((mod )) to divide in excel ?????????????

I want to use a listbox for a cell. But I want to have 2 different lists to
choose form based on what a certain cell is. EXAMPLE in cell A2 I want to
have a list box. Now if A1 shows "2418" then I want A2 to have a list showing
different options. And if A1 shows "2499" then I ...

I have been given a spreadsheet log of over 1100 audio files, with the
duration of each file given in seconds( eg '57').
I need to convert the seconds to timecode for import into a video editing
application.

On a worksheet, I have 100 pivot tables. Let's say one criteria of each
pivot table is "month"
Ho can I do in order to only type somewhere the month (let's say in A1
for example) and this month is then automatically populated to all

could you tell me how i could auto calculate multiple excel spreadsheets.  
what i'm trying to say is, in a folder on our network, there are multiple
excel documents.  we have to go into each document and go through Tools, the
Auto Calculate.  is there a way to just do it once or ...

Can any body tell me why when I go to divide with the MOD function it does
not work ?? I am trying to use a1((100)) and divide by  2 . anwser is 50
Does the divide function array work ??? If I try and type in mamual it works
 (( =a1/2  it works ????

I am trying to tie a formula to a cell that contains a starting date.
However, when this "starting date" cell is empty, I want the
corresponding formula to read it as zero.  Because the "starting date"
cell is formatted as a date, the corresponding formula seems to still

So I have a spreadsheet with a bunch of cells that use a UDF.  Sometimes when
I open the spreadsheet, some of the cells that have this UDF show a #NAME
error.  Pressing F9 seems to clear these errors.
Is there some setting which forces UDFs to calculate automatically?