Hi, I want to check a column (lets say H) if there is a 1 value i want excel to color the row. lets say there is a 1 on H6, I want to fill a color to row 6....

Hi, I have a workbook, Master sheet containing this info :cell A4 contractor name, B4 site location, c4 job cost etc to G4. There are several contractors...

I need to know if there is a way to create a formula that will allow me to enter multiple values in a cell at different times and this formula will sum there...

I downloaded a Statistical Add-on for Excel. According to the help entry, I am to look for the Analysis Group under the Data Tab and then click on Data to...

Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are...

Hi All I have a question which i am hoping someone will eb able to help me with, i have a spreadsheet which contains infromation for part time hours worked...

I am making an invoice that will figure a discount for a certain amount of sale, all from the same cell, if the subtotal is 500 then they will get...

Afternoon, I know some one out there might be able to assist me with my dilemna. In Sheet1 I have a list of 8 digts id numbers in column A and in sheet2 is...

i have a diary , i would like it to open at the specific date every time i openen the file.PLEASE HELP

I like to format a column such that it allows only distinct values. for eg in the column A i have 10 numbers 1to 10 (A1 to A10) . if i enter any value between...

Hi, I have an excel workbook with a querytable on a sheet The querytable retrieve data from a web site, and I need that data to be checked automatically, and...

greetings......i have a row in which if say a4 contains the word help, then all that row is in red text, othewise it is in black text a1 a2 ...

how can we input a monthly charge every 21 st of the month the amount $25 shall automaticaly be entered on the same sheet

I'm a Newbie that's been missiled into a job that requires many spreadsheets to track recertification dates. The sheets are no problem but I'd like to be able...

Hello all! I wish to obtain the average of a number of numeric cells but wish this average to be ongoing rather than restricted to a range of cells. For...

I have a multi-sheet 2003 workbook. Sheet 1 is a summary that displays data from the other 4 sheets, the name of one of which is "Northeast" (though...

Per below list, i want to change colour of a cell whose value matches with CELL A1 contents. For example: A1 = 239.05 Column B 1) 235.66 2) 154.60 3) ...

How do i get excel to replace words from data imported from the net. Here is the problem. I am using excel to fetch data from a flight timetable, however,...

J10:N40 may contain data pertaing to 5 activities on each of the days of the month. I need some help to detemine the total number of day's...

Halo, im a newbie 2 both VBA and Excel, I was assigned to design a VBA script which can post query and retrieve data from an excel sheet, is it possible to do...