General

conditional formmating - formulas
In conditional formatting I would like a certain row of dates to turn a colour when a report is sue in 60 days and they a different colour when there due in 30 days. Also included in the formula I need the colour to remain blank if there are no dates in the column ... 25 Jan 2010 13:58

NK2 not corrupt but not being seen
I have one user whose nickname file bombs every 3-4 months. It's too regular to be coincidence. The file isn't corrupt and there is data in it but it's like Outlook doesn't see it. He keeps having to rebuild it from scratch. Outlook 2002 with Exchange 2k3 fully patched runnin on XP SP3 fully patched. Any... 25 Jan 2010 12:49

How to change the scale in Excel 2007?
Hi I wonder how to change the scale of a diagram created in Excel 2007! You see I'm into SEO, where I would like 1 top be on top and greater numbers should come under. All the diagrams I've created starts with 0 at the buttton higher number above, but that is not what I want I want it so that I can see ho... 25 Jan 2010 19:39

route to recipient function not working with Windows7
We have many Excel spreadsheets that utilize the "route to recipient" function. (This is one reason why we are not upgrading to Office 2007 as this functionality was removed from Office 2007). I have a Windows 7 professional machine that has Office 2003 installed, and when you click on "route to recipient", it ... 25 Jan 2010 06:09

HOW DO I ... (ASAP PLEASE!!!)
.... write the formula for the following in cell K23: If A23 has a name entered, k23 returns $10; otherwise, k23 is blank. Thank you! ... 24 Jan 2010 21:28

Spreadsheet Stuck
I created a workbook with several spreadsheets, and saved it. When I open the file, the sheet doesn't expand all the way. Normally I would click the upper right corner to maximize, but it's missing. Even if I close and reopen the file it opens off center, and I can't drag, resize, or expand the sheet. I can ope... 24 Jan 2010 20:22

How do I copy the wording of a cell into a tab?
I have a large workbook with the tab titles available to copy to save typing every single one, is it possible to populate the tabs by a form of copy-paste ... 24 Jan 2010 15:51

ADD (A3+A1) IN MS EXCEL & I WANT OUTPUT IN CELL A3 HOW ?
Dear ALL, I want a macro for following scene...plz help any body... I HAVE TWO VALUES IN CELL:A1 & CELL:A3 NOW I WANT ADD THE TWO VALUES IN THE SAME CELL A3 & IF I CHANGE THE VALUE IN A1 THEN THAT VALUE TO BEE ADDED TO A3 VALUE(MEANS A3+A1) & SAME ...... HOW IT POSSIBLE PLZ GUIDE ME. EX: A1=... 24 Jan 2010 15:51

Page Layout - Orientation - Landscape
I have just installed the Office Enterprise 2007 product on my laptop and when trying to create a Landscape Excel Spreadsheet, the options for Landscape and Margins (Custom) are greyed-out!! This is the 'full' product Home Use Program for military personnel - how do I reactivate all the greyed out options? ... 24 Jan 2010 05:43

Excel 2003 restarts after closing
Excel 2003 restarts after closing the program. Word and Outlook also. What is causing this? I have an HP notebook with Vista and Office 2003 Professional Edition. ... 23 Jan 2010 08:45