I am trying to color fill certain cells based on the input of another cell
using the IF function
ie: =IF(B20 = "x",E30:e45 would color fill yellow,leave it alone
I  hope this makes some sense

Thanks for the help
On sheet one I have a list of items I inventory.  The list is by vendor and
I cannot use a sort because I would lose vendor order.  Below is an example
of the data I work with.

I have a CSV file, and it must remain a CSV file because I use it to bind to
a DHTML page using a data source object.
I have a column in there called "salary", but I want it to be listed to 4
decimal places, ie 1.6700 not 1.67

 I have been struggling with this for a bit now.
   I have items available for purchase in E8:e66 (using list validation).
   I have item written in $r8.
 I have the actual cost paid for the item for that particular purchase in

I have created a drop down box with many entries in it.  Is there a way I can
begin typing and have it find the first match and then select with the mouse
the right one?

I have:
YY   MM   DD
2     9     20
4     3     15

How do I find cells that contain specific characters and pull them out of a
long line of cells?

problems with TRUNC
--------------------------------------------------------------------------------
Hi,
I seem to be having trouble with the TRUNC formula!

if i use the following formula it gives me an error message that reads as
follows:
You've entered too few arguments for this function??
Can anybody tell me why?

hi guys , this is my problem:
i got two worksheets and sheet 1 has got datas and sheet two is exactl
as sheet 1 and the datas are reference to sheet 1.
so in sheet 1 A1, the value is 5

I have column A with dates, Colum B with $.  I want to sum a dollar amount,
only if it falles within the date range.

I wish to import data from one workbook colum (B) to another workbook colum
(A) the data is in alpha numeric eg:SY-50185-k-02. I dont want to affect the
existing data I am importing to, but I want to update any data that is new or
different to the existing.

Can you have a set of Cells (7) one for each day of the week.
that can be claered at the end of the week but the vlaues of the sum
still be avalable ?
so A1 is for Monday and its value along with A2 A3 A4 A5 A6 A7

Just wondering if there is a way to save the current worksheet as tiff or
jpeg file. I have a worksheet that I need to insert it in the PACS and our
PACS only accept JPEG or TIFF or DICOM format.
Thank you in advance.

How do I show -ve numbers with minus sign; +ve numbers with plus sign and 0
without any sign on Excel?