I can find no obvious reason, but after trying several views, restarting the program, etc., when I click Format, Conditional Formatting is "Grayed Out" and I...

I have a huge number of lists that I am calculating. I have a vertical list of numbers each vertical cell represents a week. I am trying to add up a varing...

I've got a table of data that I'm working with and trying to get displayed the way I need it. There's a "Status" column that has one of 4 valid status...

Hi to everyone in the N.G., I'm using the WORKDAY function in a cell. In the cell A1 I wrote a date and in the cell B1 I insert a function like this...

Column d = date (mm/dd/yyyy)....column contains multiple days in month, months in year Column f = widget Column h = sales force I need a formula that will...

I am intrested to search either two numbers or text in one sheet. and both text or number should be highlighted. How can i do that????

Hello, I have rows of data where in row 1 there is a threshold value (problem is that the threshold is different for all samples from A to for example E). In...

Hi This is a big ask but does anyone know how to data in one column to show different data. What I want is to have a column with data and at the bottom have...

Hi, having a problem with my timeshett system and wondering if anyone can help?? I have the following in Cells.Range(A5:J8) Mon Tue Wed ...

I've seen it, used it but can't find it within Excel. X-porting data to a *.csv file. Re-order of fields from input file to output file - which will be...

I'm working on a spreadhsheet and am having trouble with column widths. When I tried to format the column width, it tells me that the document is 'read...

Hy, How can I make formula which can link my table with different seasons and different price types for each season? For example: I have price from 12th May...

i have a table with months in column B and names in column a and % scores in column c. i want to create a formula that states if column B="nov" and column A...

Hi, Sure this is a no brainer for any1 out there reading this but i just cant seem to do it: Basically what i want to do is count the number of times a...

How can I format a cell, that if a value is entered as a whole number it will appear as entered e.g 12, but if a decimal is entered into the same cell it will...

OK, this is probably an easy one, but I can't figure it out. We (two of us) keep a list of patients that we put PICCs in, I want to have a small table...

Why does my vlookup formula return N/A when the search item is exactly the same: i.e. employee name e.g. C J Fourie? I'm running Excel 2003.

In Excel we can create specific column headings in order to import them later to outlook. Those headings are usually the letter heading (top row) Can I use...

My cells are not regonizeing the format I indicate unless I double click each cell and then it responds accordingly. I.E., I have conditional formatting and...

In an IF statement, what do I need to write to say that if cell A1 contains "fred", (i.e. " * fred * ") then.. "Yes". (I'm not sure what operator is needed...