I have many rows and columns of data.  For each row I want to highlight
somehow (e.g., change background color) the entries in the columns that don't
match the value in the first column.  Thanks for any help.

I use Excel to edit various types of files, such as IIF (QuickBooks list
files).  I used to be able to right-click on the file and choose Open With
and then Excel was listed.  Recently, I noticed that Excel is not listed and
so I have to browse through the programs menu, and then ...

I am wondering how to cause a Cell to change it's text color without using
the color selection tool. I use Excell to create a 30 person Schedule for
each week of the month. And any time I have new employees, I change the text
to Red to represent newbies.

I have 3 columns in the workbook, 1 for start time, 1 for end time and last
one is the difference.
The difference I get is in the HH:MM:SS format. I need help in coverting
this result into total minutes.

I have 2 worksheets in a file.  Sheet 1 has personal details of
clients & Sheet 2 has details of training that they have taken up.
When completing sheet 2 I have created a drop down validation
referring to the surnames on the Sheet 1 and when selected it brings

How can i calculate progressive tax. For example if all income up to 200$ is
exempted from any tax and :
201-500   taxed 10%
501-1000 taxed 15%

How would I find the last (bottom row)  of data when data may be missing in
some columns? I'm trying to set Chart options on the run with macros instead
of setting the bottom row to a default value such as row 1000. The number of
rows is changing depending on options picked from ...

I have set up a macro to unhide 5 rows on a worksheet and have also set up
another one to unhide the same 5 rows. I have set up a checkbox and have been
able to use VB editor to run the 'hide' macro when the box is checked - how
do I use VB to unhide the rows when the box is ...

how do you work out how many days there are between 8/8/2008 and 3/9/2010
Cheers

I need to count days between 2 dates in 2 cells. Like B:2-B:1. In case B2 is
empty i need that to be counted as on today-system date. Can you help on that?

I have an error occuring when I try to run this simple bit of code. The code
is:
Sheets("Name").select
Range("A2:D26").select

Can I insert/embed a word document in a single excel cell? a cannot use
hyperlinks as the recipients of the excel file will not have access to the
required network.
I would possibly be attaching one file per row of a spreadsheet.

Hi, I have tried to count the colours on a spreadsheet. I have  copied
Pearson Consulting functions for counting colorindex, which I have managed to
get working when at another company, but when I put the formula
=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3)) in I get the #NAME? ...

i WOULD LIKE TO ABLE TO INDENTIFY COLUMN THAT A DATE IS IN
I.E IF DATE IS IN EG B17 THEN I NEED A FORMUAL SAY IN A1 THAT WILL IDENTIFY
AND ENTER B IN THE COLUMN.
THANKS

I don't know if this can be done, but I would like Excel to be create an
order form. I have a list of, say 300 items and in one instance need to order
only 3 items from that list of 300.  I've chosen the quantities I require of
those 3 items, however I only want to display the ...