General

How do I get a cell to auto change red when a certain numbe is ent
I would like the cell to change red when i put a number 5 or lower into the cell ... 24 Feb 2010 21:07

how do you add times together to give a total time?
I want to add together a column of times on telephone calls. ... 24 Feb 2010 21:07

Inserting pictures into Excel Sheet at a particular size
We have about 50 pictures we need to print for an in-house brochure. We have decided to import each picture into an Excel sheet. We decided to do that because we want to type a caption underneath the picture. We want the picture to print landscape on an 8 1/2 X 11 sheet of paper. We have the margins set t... 25 Feb 2010 14:51

4 field lookup
I have 2 spreadsheets (sales and returns) that I want to match 4 columns on and if they match pull the P column from the Returns spreadsheet. I found some old posts with a formula I tried to follow, but I get 0 everywhere. I have no idea what this is doing. Can anyone help me? Thanks, =IF(ISNUMBER(MATCH(1,(... 24 Feb 2010 16:35

Identify Whole Number
How can excel identify a number when it is whole or it has decimals. I am doing an IF function. E.I. If(A1=WHOLE NUMBER, YES, NO) Is there some way? ... 24 Feb 2010 14:18

Splitting data in a cell
Hi all I have a list of data in a column (see below) which I need to split the last 10 characters (date) from the rest. I can't use text to columns as no characted separates the data from the date, and I can't use fixed width as the data before the data varies from 2-4 charaters. Any ideas? SES106/07/2010 ... 24 Feb 2010 13:10

Trouble creating table
When I follow the directions to create a pivot table from the workbook, the data is all transferring into Row A, with other field data beneath it, and I'm not getting any Row B, C, etc. I did exactly what was shown in the tutorial, but it's not coming out the same. What's the problem? ... 24 Feb 2010 12:01

EXCEL-2000 column headings hide from data
How do you make the column headings where they don't show in data validation drop down box? ... 25 Feb 2010 13:43

How to have charac in new column with 40 char length only...
I have a below requirement: In one column i am having some words of different-different length, e.g some 70 charac., some 60,50,100,90 etc. but i want to have all of them copy to new column but with length only 40 charc....rest of the charac i don't want.... plz help. Thanks in advance Rajat ... 24 Feb 2010 12:01

Upper Case Letters to First Letter Upper, Remaining Letters Lo
=upper(left(A1), 1) & lower(mid(A1, 2, 100) Will turn generate "Quick brown fox" -- HTH... Jim Thomlinson "KC" wrote: The formula =PROPER(A1) will make every first letter of each word upper case and the rest of each word lower case. A1 is the cell you want changed to upper/lower. So QUI... 24 Feb 2010 13:10