On my spreadsheet I have a list of training due dates. I would like to setup
a conditional formatting function to the entire spreadsheet that if anyone is
due training on or before July 01, 2006 to turn the field yellow.  What would
the formula be and how can I apply it to the ...

I am trying to have a document with many dates, automatically become
highlighted once the date has expired.

I recently posted a question which received not a single response - so I do
not know if what I want to do is possible, or if I have asked the question
in the correct place.
Perhaps someone will be kind enough to let me know?

Calling all Geniuses,
Is it possible to trim down something like this, I have over 4 thousand of
these, they are SKU's with case pack size
9811HAC-6, I need it to be just 9811, I need it to strip the HAC-6

Hi, im using excel to record sales. in the input sheet i have varibles
such as the total cost of the sale, employees name ect.
now what i want to do is extract the varibles from the cell and move
them into my past sales sheet. sounds easy to me, but i want it to like

I have a weekly task where i need to report progress on 17 asset areas each
with 7 of their own workbooks, progress is simply looking at number of null
cells per workbook etc.  The problem being that each of the workbooks have
been split up to make the size of the data more ...

I have a worksheet where data could be the same for first two columns of some
rows. I would like to supress this and show the data only on one line.
e.g if I my data is like
   Apples  green type1 10

How do I create a conditional formula that hides a complete row or rows if a
value = 0? I want the rows to disappear so that I can print out only the
information for rows that have information in them.

If cell A2 contains todays date (using the NOW() formula) how do I get the
contents of A1 to be displayed either in bold and/or different colour?
tia

my Problem is the following: I have a Excel Sheet that has many fields
of information. In addition I allready managed to create Names and
Conact those names to cetain colums by means of using the Validation
feature. That creates a drop down selection. Now I want another drop

I have a worksheet with ~ 800 rows & ~ 20 columns. One of those columns
contains an unique graphic for each row, so I have ~ 800 graphics.
My question is: How do I "lock" a graphic to a particular cell. For example,
when I hide/unhide columns, the graphics move out of the cell. ...

I have this fairly large dataset with two kinds of missing values (NA):
1) Holes should be filled with the first before the sequence of
missing values (i e a constant level up to next value)
From:     ...30 31 29 NA NA NA 31 32 NA 34

I am looking for a way for my formula to reference the same group of cells on
each page, but the sheet name needs to be able to roll when it is pasted (so
I don't have to keep editing it). for example:
sheet1 A1:A7

I need to average only the last 30 entrys in a column of data automatically.
Any suggestion will be appreciated.

Sheet one of my workbook is database that subsequent worksheet draws info from.
The subsequent sheets are all same template with VLOOKUP / INDEX whos return
contingent on entry in one cell in the sheet.
I would like this one cell to equal the TAB or SHEET name.