I am trying to set a color to a certain amount of cells after a date is shown. I can get the cell that contains the date too but i cant get the rest of the...

2 collumns with numbers, what would be a formula to identify which is less and the answer of "TRUE" should be in color blue and false should be red? -- smile

Hi, I am manipulating data from one db to another and have found that I need to have the ID numbers 1 to 6000 in the left side 1st column. How do I get...

I know you can enter a comment so when you scroll over the column it will show the comment no matter what line you are on, but I can not remember how to do...

I have a budget that I want to automatically add the contents of one column as I'm working on the sheet. I am new to this and I need all of the helo that I can...

I would like to add a date picker to an excell sheet is there an easy way? thanks for your help tab

I have a spreadsheet which lists a date and time as 1/02/2007 8:31:36 AM. I would like to be able to add the day of the week for the date in column A. It would...

i would like to add 90 days to a date and have it stay green, and trun red on the 80th day can this be done. -- cj

Hi Trying to add 4 days to date in cell A1, without counting weekend and if poss bank holidays. in cell C1 example cell a1 = date cell b1 = time If time...

How do I integrate a long custom formula in a macro ? The formula will be used to manipulate a column of data. Do I record myself actually typing the formula...

Hi. I want to know how can I do to add a function for use like Max() or Min()

I know how to add gridlines for Excel 2003. However, someone in their infinite wisdom (yeah?!) decided to make Office 2007 products difficult to use, hard...

I think I did all the right things to add an ADDIN but it does not show up any where. Here is what I did Go to EXCEL option and select ADDIN click on the add...

I have a list of over 1000 names in my a column but need to add @gmail.com to the end of all of them. How can i do that in excel?

I would like to create a spread sheet for book keeping purposes at my church. I am responsible for counting large sums of money and I would like to plug in...

I need help with Xcell 2003 program as I have difficult time following the help instructions. I have a list of names arranged by last name, first name,...

Back in the old days in Excel 2003 when I had a graph and I wanted to add a new data series all I had to do was click on Chart--Add Data and it was easy to...

I have a very large spreadsheet that I'd like to break down into multiple worksheets. I have only three columns that I need repeated on each worksheet. When...

I Downloaded an excel template which has four pages and a summary page with all the details of the four pages and their figures added together. My problem...

I think I posted this but I can't find it anywhere so here goes again: A1 displays "Week 1". I want B1 to display "Week 2" using a formula. I learn how to...