Reviewed some threads and still got me lost...what i am trying too do is get
an cell to high lite when an item is coming due within 5 days of the current
date....IE; today would be the 23 sep want an item to high-light when its
with-in that window....any help would be appreciated ...

I have an excel file that I'm distributing to other users and they have a
problem where excel defaults to design mode when they open the file, this
causes them have problems like selecting the textbox object rather then
putting the curser in the box. they do not know how to exit ...

I have an excel-worksheet as follows
Date                Weekday           kg (kilogram)    packages
04-09-01        Wednesday            15000                    26
04-09-01        Wednesday            14000                    24

this is my problem:
A1        time in  [1:00am]      
b1         time out [1:45AM]
c1          running hours

Who can help me with a formule to solve this problem
The outcome of a som is for example "1" in cel A1, then I want that in
cel a2 it says "0", is the outcome in A1 "3", then I want that in cel
a2 it says "3", but if the outcome in a1 is between "1" and "3", than I

I have read a lot of posts, and maybe I am way out of my leage.
I am trying to setup a spreed sheet for our fire department.
We want to create a way to track training pay. When someone attends the
training we want to just put an "x" in next to their name in the column for

Can you add a variable number of columns?
I have a value in cell A1 which can be a number between 1 and 12.
In cell B1 I want a formula which will give:
If A1 = 1,  B1 = A2

I have fwg tabel
Mol%    Counts
0.00225    836.95
0.00225    834.69

For some reason the alt+enter function does not work for me when trying to
insert a line break within a cell. Is there any other way of doing it or,
better still, any way I can enable it?
I'd appreciate any help I can get on this one as it's driving me crazy

I have 4 cells, A3,B3,C3, and D3.
=IF(OR(A3="",B3="",C3=""),"",A3+B3+C3)  (for when D3 is absent)
=IF(OR(A3="",C3="",D3=""),"",A3-C3-D3)  (for when B3 is absent)
How can I combine these two formulas into one cell?

Ever used graphic design programs and notice the history of each step that
you took to accomplish something. well that same functionality should be
incorporated into the next excel. as a student i often find it helpful to
look back at what i did to see how certain functions were ...

I work for a restaurant that uses a point-of-sale system and a liquor
control system to keep track of sales and inventory. My problem is how to
reconcile what was ordered in the pos system with what was actually poured
in the lcs system. Since the liquor system dispenses potion ...

I need another way to take the contents of two cells (City and State) and go
find whether they exist on another workbook that contains a sheet for each
state. These sheets are each named for a state using a 2-letter abbreviation.
The cities are listed in column A of each sheet. I ...

How can I set up conditional formatting so that I can compare data in a
column to baseline data in adjacent cells so that I do not have to do it cell
by cell?

I need a validation that takes either a dropdown list with an indirect(A1)
reference off of one cell in the case that a second cell has "internal" in
it, or an "any value" validation if that second cell says "external".  
Example: