I am using Excel 2003
My suggestion is that when using the "IF" function there should be the
opportunity to colour a cell with green, if true, or red, if false. This can
serve to highlight or draw attention to the the outcome, even better if the

I have a pivot table report that displays ONLY the resources that left or
started with the company (grouped by manager).   The execs would now like to
see percentages:
a) percentage of resources left/entered against # of employees under a manger

How can you add/modify a selection in the Header/Footer drop down box?

I need to highlight when data is input on a date previous to today's current
date.  To track whether employees are inputting their information when the
work is performed or at a later date.  I cannot determine the formula
necessary within excel to complete this task.  Any help ...

Howcome I can't count down with autofill? If I put a number into cell A0 and
then make cell A1 = A0 - 1, when I auto fill it doesn't count down in - 1
decrements.

Using =HLOOKUP(999999999999,F2:AC2,1,1) I am obtaining a last date entered in
E2.
Must type date in DD/MM/YYYY format.
To add how many time a date (by month appears) Im using

Column C contains the day of the Week.  Column D contains the clock-in time.
Column E contains the end of the day clock-out time.  I am currently using
the formula =Average(D:D).    
When averaging a column of clock-in times, can the values for Saturday &

Can someone please tell me why this function does not work:
SUM(IF(E199>"0",SUM(E199-D199)))
In case I have it all wrong, if I have a Value in cell E199 and I want to
subtract E199 from D199 provided that E199 has a value in it, if it does not

I need to know how to change the background color of a cell based on data
entered. Such as a date that is more than a year the background of that cell
turn red.

I have a value in Sheet1 Cell A1.  I want the value to be repeated in Sheet2
Cell A1.  In the past, I have clicked on the destination cell, entered =,
clicked on the source worksheet, then on the source cell, hit Enter, and the
destination cell was linked to the source cell.

Hi I am trying to lookup a value on one worksheet, match to a second
worksheet then pull in a text value from the second worksheet to the first
worksheet.
Thanks Kelly

I need a formula that brings back a set amount of information when there are
variable amounts of information in the selected cell.  I am working in a
spreadsheet where column a has numbers of different length.  I am trying to
create a formula that brings back a variable amount of ...

sheet 1: Sheet1. Cellcontent A2=1
sheet 2:
Try to write this:
=Sheet1!A2

I'm trying to calculate an average of data, but need to ignore negative
numbers in the range from which I'm taking the average.  I'd like to either
format cells to calculate based on displayed values rather than actual values
OR use something like an IF function to change ...

I need to change weeks into months. Like having weeks 1 through 5 be called
Jan.
and so on. What is the easiest way to do this.
Thanks,