I know this must sound stupid, but could anyone give me a
hint on how I can change the color of a cell automatically just by clicking
in it.
What I'm trying to make is a Grid with 90 Cells for a Bingo Presentation

How shall i do a formula to make a time sheulde. (for my work hour.)
I have made cell 1 when i start the job , cell 2 when i stop the work and
cell 3 forpause/food time and cell 4 the sum hour my working day.
It work fine when i work on the ordnary day but when i work late or night ...

How do I filter the rows where in column B a cell is not a blank?
Then presumably I can delete only those rows resulting in a sheet wher
every cell in column B is a blank.
Thanks

I am looking for assistance with splitting data between cells.  I have a
column of data (first (space) last name).  I need to split that column
into two seperate columns so each name value is in it;s own cell and i
end with 2 seperate columns.  

Background: We have a Workbook with 58 Sheets for our Riding Club Shows (one
for each class) When a Competitor enters the horse show they select which
classes they wish to compete in. Currently we type in their details in three
columns on the sheet for the first class they enter, ...

Would like to set up Excel to keep mileage to my Doctors appointments. Need
formula, function to do this. All I want to have to do is put my doctors name
in and have it put his address in and roundtrip mileage. Then the esay sum of
all trips. I can do that part.

I have a huge workbook with some 200 worksheets (Excel 2002) and wouldlike
to create one single worksheet by appending the data on all worksheets one
after another. Is there an easy way to do this without programming a macro?
Thanks so much.

I cant seem to acces the conditional formatting thing in the formulas pull
down.
I would really like to use this feature, It just is always unavailible

I have a spreadsheet that requires the entry of 567 answers to
assessment items designated by "True" (1) or "False" (2). I have cells
A1-A567 as the cells where this information is entered.  It is tedious
to have to hit "enter" after each 1 or 2 is typed.  

My question may be quite simple, but I have not been able to find any
info on it (due, no doubt to ignorance)
I want to use the info from an input box to fill certain cells,
basically prompting the user for the info to populate the cells.

On Sheet1 I have a list 5 columns wide.
When a row is added to the list I would like to add a row to a list on
Sheet2.  The third column on the Sheet1 list would drive the value in the
first column of the Sheet2 list.

I am trying to create a birthday list cake roster that can be easily
updated as staff come and go. Basically I have a list of names in the
first column, their birthdate in the 2nd column. In the 3rd column I
want the name of the person whose birthday fell before the "Birthday

Everytime I have had a problem and turned to this newsgroup, my
problems have seemed monstrous. The solutions the wizards have come up
with, always seem so simple. Hopefully someone can help me again.
i need to write a macro that will search a range of cells, and copy

How do you split two sheets onto the screen

Need to work an exercise where I click on the sum icon to add rows of figures
in a spread sheet and the sum icon is not at the top of the screen to click.
Why would
it go away?  It was there last week when I was using the fx function. Would