I have modified several colors in a worksheet, what can I do to verify
the user sees the same color as I intended (I understand the
differences in monitors, software, etc - but would like a similar color
to show.

My SQL already removes duplicates and some rows that are blank
with this:
Select * From itran INNER JOIN ihead ON itran.it_doc = ihead.ih_doc WHERE
itran.it_status = 'A'  AND ihead.ih_quotat = "" AND itran.it_stock  <>""

Here's something simple that I can't figure.
Say I want to look in a cell and if either of two things appear, I want to
count the cell.
Here's the formula, with the touchy part toward the end:

We are exporting tabular data in tab delimited format. Some names that
are exported may well begin with - +, can look like a number: +section
etc. During export all names are quoted, e.g., "+section". However,
when opened in Excel all such names are misinterpreted as formulas and

Another seemingly simple process which I can't figure.  :)
I have a list of averages, and I want to get the average of them.
As such,
     A

I would like to know if it is possible to have  validation on data
stored in another worksheet.  I tried to use validation in sheet1 with
data stored in sheet4 but a message existed to decline my request.
Regards

In pivot table, data column. I would like to show several columns of data.
Please instruct me how to do it?

Where is the organize dialogue box for Excel Macros?  I found it once, but
can't find it again.  I created macros for a spreadsheet, organized them so
that they were attached to the spreadsheet and then sent it to someone else
to test.  The macros worked fine and they liked the ...

My boss will have my head if I don't figure this one out tonight. He wants
the text from the document (which can be long in some cases) embedded in the
cell  - does not want the floating document. is there any way to do this? And
if so, is it a case of cut and paste each ...

I created a custom toolbar button in Excel when I was running W 2000. I
moved the customization file to my new XP computer. I also moved the
associated macro. Then I connected the button to the macro. However, when I
click the button, I get an error message that says the process is ...

I'd like to build a form that can be used on a Pocket PC and then transfered
to a desktop PC.  I do home inspections and rather than write a longhand
description of the house and related issues on the job site, I'd like to use
my Pocket PC, calling up an Excel form that has basic ...

This seems quite mundane after reading some of the things the rest of you are
working on, but!
I am building a payment booklet. I will be putting 4 payment coupons on each
page, to total 180. I put the start date in a cell (and the payment # in

I am trying to use conditional formatting to show when a date is less than 30
days in the future. When I use "cell value" "is less than" "="Now()+30" all
the dates change.

ECX=00af9194 one file won't open. It is used daily. How can I
troubleshoot this ? Thank you

Good Afternoon,
Could someone please be of assistance. I am currently a new user and I am
having difficulty with "IF" statements.
I am working on a spread sheet that has various departments: