How to change default font color in Excel 2007?

ok guys. here is my problem. i am using several sumproducts and adding them together to get a value. note that the range I am suming is the same...

Hi all, I have rows of data being recorded for different dates. The number of data points for each date changes (normally 1-4). Since I don't know in advance...

The context window that should "pop-up/out" when I click on Cell Styles on the Home tab is "locked" on to my ribbon. Normal, Bad, Good, etc. is on one line...

Is there a way to show the mapping of hyperlinks on a worksheet? -- mamalhe

Thanks to the Disscusion groups I found the following to delete blank rows: Sub macro_der() Dim i As Long, nLastRow As Long Set r =...

Hello! I know this sounds crazy. But does anyone know how to create a sudoku game using excel 2003 that has a timing function to it. Meaning, I am able to...

I would like to caculate the total in column A for those date more than 21 days until today in Column B, can anyone...

At least I think that's what I'm looking for. here's my situation: I've got a sheet where there is a variable (X) that changes depending on what row it is on....

Hi All, I've been experiementing with the Sumproduct function in Excel 2007 and ran across a problem with the function that I cannot figure out. The...

I have the following data and need to extract only the data where the value = false The true / false is Column D with Column H A B C ...

I have 12 tabs (same worksheet) that I need to average a number in cell b6. The issue is sometimes there is a zero in b6 and I do not want to count it in...

-- Murphys Law that pertains to computering: Anything that can go wrong, will go wrong.

I want to take a fixed number in a cell, like 84543421, and I want a formula that will display it as 845434.21 but I don't want to type the number over again.

Is there a setting in Excel 2007 to keep it from automatically trunkating leading zeros like when pasting in zip codes or department codes. When Excel sees...

The count function is not working in one of my workbooks. It works in others and in new ones. The workbook it is not working in was created last week. It...

I need help with Excel 2003. I have different conditional formatting in columns A through S. I've intentionally left row 2 blank. What I am trying to do...

Hello I open several Excel spreadsheets daily that include a date/time column. Every spreadsheet that I open I have to change the column formatting to "dddd...

Hi Everyone, Using Excel 2003. I created my first pivot table being guided over the phone and didn't quite remember how I got it grouped by years and...