Hi I want to change the color of the worksheet tabs like different tab color for different sheet Is there any way i can do this by writing a VBA code. Thanks

Hello, In Excel 2003, I would use CF to compare two columns of numbers. Assuming colA and colb had the numbers, I would put the following CF in cell...

i need to find specific text on a sheet and return the cell location of the found text... how do i do that?

I am entering 12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided...

I have a worksheet with 40 rows (this number of rows will not be static). Each row, in column "M" needs to cycle through about 10 IF statements. To accomplish...

I have a spreadsheet with various test results. I ask the user to copy all (only option) the records once a day and paste into these into spreadsheet from...

I have an Excel spreadsheet that gets up to date values from an external source using RTD. At the end of the day, I save the sheet. If I open the sheet and...

I've got a payroll dump where everything is in caps (eg First Name and Surname) - about 2000 rows. To make it easier on the eye I'd like to add new columns...

I am working with a formula in which the value of one of the inputcells changes dynamically (stock quote). What can i do to automatically put the changing...

Looking to get a formula for the following scenerio: if H1 is greater than I1, then J1 is "Yes" and of not J1 is "No"

Can anyone help me develop a worksheet function, set of functions, or macros to get this going? I need to calculate the Total number of times a Part# is...

I can't see the activex controls embedded in a worksheet - they're present because I can click on them but they don't show on the sheet. How do I make them...

I would like to do a conditional format - like if the total are higher than 100 it should flash in red.

Hi All I'm using a hyperlink out of Excel to a .chm help file. Every time I click the hyperlink , I get this message : "Opening C:\_tmphhp\help.chm Some...

Pivot table short cut keys and more options required very urgently

I have a spreadsheet that in simplified form looke like this: A B C D E F G H I J K L M N 21 0.3 34000 ...

I like the COUNTIF function but want to include the ability to expand the "match" criteria to include data in other columns. Possible?

How do i change the string of number into text. (Not just the format) When i key in "US$1,234.00", another cell will appear "United States Dollars One...

can the border of the cursor cell 'input cell' be changed so that it is more pronounced?