I am trying to apply a conditional format to a pivot I created.  If the value
in the cell meets, exceeds or is below the target it should light up to the
colors of a traffic light.  How can I have the conditional format ignore
blank cells?  Right now it is highlighting all blank ...

i have my number in E11 and E10 like this
E11 "884.90"
E10 "868.05"
i want my ans as E11-E10/E10 like this (868.05-884.90)/868.05

I have created a user defined function and I need to know how to get it to
update automatically or is this not possible.   I have some fixed values for
the input variables and it's pulling data from other sheets that update from
time to time.   Do I need to change the input ...

I am a relative newcomer to Excel, so forgive me if this is either
impossible or a completely backwards way of working.
My boss has given me a challenge to turn a huge spreadsheet he has of
projects into neat individual report style layouts which he can print

Have data spread sheet using vlookup, when I leave A7 cell blank this roll
has #n/a the column A1 to A50 are my lookup, if I use any lookup it works but
if left any cell blank I have tons of #n/a how do you get rid of them or fix
it where it doesnt show when not used. I have try ...

My Question is how do I create a worksheet that contains only rows that
contain a certain name on a different worksheet.
I have an exported list of data that contains information for different
users. Would like  a formula that will return the row only if it contains the

Is there anyway you can disable the exit button X in excel 2003 as I
only want the users to close and save the workbook thru a button macro
on the worksheet???
Thanks

I hope someone can help me.
I have a workbook with 3 sheets.  sheet1=Data Entry, sheet2=daily hours,
sheet3=8day totals.
In sheet1- col a is name, col b is date, col c combines a&b, col d totals

The AutoFilter will not allow me to enter a non-integer (2.5) in the percent
field. I need to filter a list to show all except the top and bottom 2.5%.
I've been looking for over an hour and can't find anything that remotely
addresses this issue. Can anyone help?? (My boss is ...

I am working on a worksheet that will be updated yearly.  Consequently, the
number of rows used will change.  I have pasted the links down through the
maximum number which could be used.  I am now attempting to do a sum of the
cells.  Because some of them do not contain data ...

I have a spreadsheet with 300 rows of data and I need a macro that will
insert a blank row after a change in the data in column B.  The data starts
in row 10.  Thanks for your help.

Hello and Help!  :-)
I have this formula that works just like I want it to as long as cell b8 is
the only empty cell below cell b7.
=IF(AND(""=B8,B8=""),SUM(C7:C8),C7)

In the formula
=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)
what do the "{" mean

I've got two columns of unique ID's.  I need to match these unique IDs in the
same rows including another column with the data that I need in that column.  
Basically I've got a spreadsheet with rows of contacts and another
spreadsheet with the email addresses for these contacts; ...

=MAX(INDEX(('data FI'!$T$3:$T$10>=W2)*('data FI'!$T$3:$T$10<=T2)*('data
FI'!$V$3:$V$10),0))
Is the formula that works for finding the max value between two dates...
change Max ti Min and I return 0.  Any help is appreciated