General

conditional format cells by date
Dear All, I am looking for some help formatting cells with date entries using excel 2003. I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen variations on this theme in other threads, but don't seem to be able to get a formula to work with the following; Date entered into cell (not nece... 4 May 2010 13:28

SOS! how do I run Excel without running the VBA in AUTO_OPEN?
Hi all, I am asking this for my friend. He has the following urgent problem. He put some VBA code into AUTO_OPEN (AUTO_RUN), basically it execute some other functions, and then automatically saves the closes out the Excel sheet. The problem now is that he wants to open that sheet to edit some stuff, n... 4 May 2010 10:06

SUMPRODUCT QUESTION?, Ratios
repost: little more accurate: hi, i am trying to add ratio's. not sure if wording all correctly. but here it goes. I will have multiple ratios, there might be 1, or 5 ratios: 1:2 1:5 1:20 5:3 10:1 I have the max value of numbers adjusted for ratio changes: 200 would rather have 1 ratio in 1 cel... 4 May 2010 01:22

SUMPRODUCT QUESTION?, Ratios
SUMPRODUCT QUESTION?, Ratios hi, i am trying to add ratio's. not sure if wording all correctly. but here it goes. I will have multiple ratios, there might be 1, or 5 ratios: 1:2 1:5 1:20 5:3 10:1 I have the max value of numbers adjusted for ratio changes: 200 would rather add the full ratio in 1 ... 4 May 2010 00:16

Current date
I apologize if this is posted twice, but the post I made earlier doesn't seem to be showing. I have a macro set up that copies parts of a large worksheet into smaller, individual worksheets. In these individual worksheets, I would also like to place the current date (the date on which these sheets are being g... 4 May 2010 00:16

Keyboard shortcut to select entire column
I am using Excel 2007. I can select entire row by using Shift+Spacebar. However, if I press Ctrl+Spacebar to select entire column, nothing happens. Has the keyboard shortcut changed in Excel 2007? ... 4 May 2010 12:21

Deleted file
How can I recover an excel file that was deleted while Disk Cleanup Ran? I noticed it the next day that it was missing and now I have more of my Microsoft Files from Word missing. Can anyone help me? ... 3 May 2010 23:09

How do I make a graph with 2 "Y-Axes" at different scale?
I wish to make a Graph, with 0 to 10,000 pounds on the "Left Y-Scale" and 0 to 100% on the "Right Hand Y-Scale" Can this be done in Excel 2003? If so, how is it done? ... 4 May 2010 09:00

Highlight on Date Problem
Hi everyone I have the following in conditional format in column A =I54-TODAY()<=60 if true highlight Red This is working in most cases but for some reason when september dates are in the I column they also highlight red which is incorrect - am I missing something in the formula please? -- Thanks as alw... 5 May 2010 10:26

emailing worksheet...
I have a multi-tab worksheet, but I only want to send out via email 2 or 3 tabs, not my working pages. Can I just send 2 or 3 tabs or do I have to always (weekly) copy and paste my tabs with changes to a new work sheet in order to send via email? I have tried grouping only tabs I want to send, but the whole w... 4 May 2010 13:29