Heading in cell D1- POS Interview Date -- Cell D2 4/23/10 (I need this cell to turn green 60 days prior to date.) Using conditional formating. Please what is...

=VLOOKUP($B8,'WPS Detail Dates'!$B:$AT,49,FALSE) pls why is formular showing #REF!. Please can anybody help me with this. Appreciate your time. Thanks

We have a pivot table of this form: Type SubType Amount a a 3 b 7 a Total 10 b ...

I used the Following Data: Copy Paste into Cell A1: Data Description 11/30/2008 Issue date 5/31/2009 First interest date 6/26/2009 Settlement...

Hi, can I use Iserror for an array? like ISERROR(A2:A300) I've tried this with a non-error array. The result is TRUE, which means there's an error in the...

In the sample below I need to be able to isolate students who have a G status for the VERREV code and an S or W status for all of their other codes. I have...

I have a rather mundane problem. My company uses Ariel as a standard font when creating documents. I've selected Arial as the standard in Excel, no problem...

I am trying to set up a date calculator so that when you enter two or more date ranges it will give me a new calculated date. (eg. March 5/2004 to June...

Hi, I have to copy data from one excel file to another. I am using the following command to copy ws2.get_Range("A1",...

Hi I have protected my worksheet to stop users from chaning information, but now the Refesh External Data does not run. I need to unlock the worksheet to run...

I have a range of N cells, all in one column and all unique numbers. I also know that Z cells from this range adds up to a number R. This combination of Z...

How to "freeze" border menu so I can do multiple borders without losing menu each time. I think it was in 2003 Excel that by double clicking title at top of...

Is there a way around the fact that you cannot use a relative reference for the Worksheet? I want to use the ending balance from June to automatically...

I have some employee numbers in the format 923 022 033. I want to put the numbers together without spaces. I split into cols and then recombined but the...

I am using a PC and working on Excel 2003. I have a spreadsheet and have random blank cells. Everywhere there is a blank cell, I want to copy the information...

Please can anybody help me check this code why is not working. If set of date below change then Latest Update date on column "10" should automatically...

I am trying to create a FAQ in Excel 2003, I have the list of questions, but I am not able to have the answers show up in a different cell. For example: if...

Does anyone know how I can add text to the end of a formula in the same cell? For example, the formula I have will compute a list of numbers and display the...

Hi all How do I compare two alike ranges with one formula and get result as true or false. Ranges are alike = true Not alike = false Cheers

I have a spreadsheet with 3 types of rows -- hardware, software, and support. Column A in each row starts with HW-xxxx-yyyyy or SW-xxxx-yyyy or...