Hello, I have 2003, I'm trying to color cells that have specific words w/in the cell. I want to count words like "*broke*" and "broken*" as the same to get...

How can I write a formula for a column of colors, (some have numbers, some don't) that will go down the column and look for Interior.ColorIndex 36 (light...

How do I reconcile two sheets with in a .xls book?

Could someone tell me how to make an Excel spreadsheet to track intermittent FMLA? I do not know very much about Excel, so any help would be...

Hi! I could use some help with filters. I have a spreadsheet I distributed to others to complete and return to me. Once I got the copies back I combined...

why would a value in a cell as shown here 8212.0011( return a value of 8212.00110000.00 when the ( character was deleted from the cell? The version of excel...

I've exported a load of data into excel but the info in the columns I want in rows and vice versa. I'm sure there must be an easy way to flip them.. Can...

In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how...

How can we hide pre-selected groups of graphics elements with the touch of a cell or control? We have two distinct groups of rectangles with gradient fills. ...

Is there a formula to obtain a total for each quarter which excludes including the year? Thus avoiding having to change to year on a yearly basis. Your...

Hello there, I am using IF function to return values as digits. Now I need the sum of such digits in a coloumn. Pease help me to do this. Thank you Jeevan

When a user selects the 14-Mar-01 standard date format in Excel 2007, then selects the custom format option, this is the standard format that...

I created a hyperlink to a pdf file ,it flashes and closes whats wrong??? \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make...

Can someone tell Both the standard formatting toolbar to show For example B for bold the Dollar sign $ and back ground bar like the color icon to appear

My problem is that I don't know how to connect to an Access database from Excel. I'm modifying a macro in which I have to compare some strings in Excel cells...

Hi, how can i make this code work in Combo Box (Activex Control) to populate data fields in excel? I got it to work in Combo Box (Form Control) but it will...

I have a lot of sums I have to add up, and was advised by my boss that it would be best to use Excel to do it; however, i'm having a hard time figuring out how...

Is there any way to "tone down" the code that Excel 2002 creates when saving a worksheet as a web page? We converted to Excel 2002 this past year at work and...