Search results for query: *

Thanks for this, it almost worked but gave me the required syntax to solve the problem. The way I solved it was =IF(G3<>"",SEARCH(G$1,$C3),"") Again many thanks

I have a spreadsheet that uses the following formula to search for some text contained in a colum in a particular range and highlight the cell where the the criteria is met. =SEARCH(H$1,$C3) To improve this I only want it to highlight the cell if it is not empty. I have played about with...

Thanks for everyone who took the time to answer. I have almost completed the task using basic CF. The final thing I have to work out is how to change the text colour of the whole row if a cell in a particular column is not blank. I have used the 'If not blank option to change the text colour...

I have used VB because when I initially searched for a solution a previous post recommended this type of solution. I thought it would be ok to post it in this forum as it is vb in an Excel spreadsheet. How would you recommend I complete this in Excel? I am using 2007 and I am having some...

I have used the following code to apply conditional formatting in a spreadsheet. Private Sub Worksheet_Change(ByVal Target As Range) Dim myCell As Range For Each myCell In Target Select Case myCell.Value Case Is = "Match" Range(myCell, myCell.Offset(...

Hi can anyone help? I work in a school where we have just adopted sharepoint and I am trying to keep up with user requests! I need to produce a survey type document, which will allow students to branch to a question a number of times i.e. which university have you applied to ....and following...

Sorted it, added my own date field and it worked perfectly.

Is it possible to generate a start date for a task in a customised form? I am using the DateAdd() function, in the text box properties, with the following code DateAdd( "m" , -2 , [Start Date] ) but it just shows the same date as the start date instead of two months before. Any ideas...

Thanks for taking the time to reply to this, but I actually have four different options. I only mentioned 2 as I thought I could just replicate the answer.

I have a spreadsheet about holiday bookings. If the word 'Hot' is entered I want the whole row in a range of cells to turn green. If the word 'Warm' is entered I want the whole row in a range of cells to turn orange. I have created individual macros to change the range to the specific...

I have a query in which I have used DatePart to separate the day and the month from a person's date of birth. I am trying to create a report that will sort the birthdays into Months. I have tried using Date of birth - month but it still sorts into the different years e.g. jan 1990 Feb 1990 . ...

I have set up a simple mailmerge from Excel into Word. For some reason the date field is shifting e.g. In the spreadsheet DOB 1/12/1958 - in Word 12/1/1958 I have checked the formatting and regional settings - all are correct and in English format. I have solved the problem using the \@...

Thanks very much for your help, the layout was just a quick fix as out database that usually works it out has decided not to play ball. As with everything in a school it had to be done yesterday! Many thanks Cath

Yes each subject has two columns one for effort one for achievement. The Effort column has the subject as a heading. e.g. ART ART-ACH BIO BIO-ACH ect. I want to be able to add up the number of A's a pupil has for effort. The problem is there may also be A's for Achievement in the same row...

I have a spreadsheet that shows Effort and Achievement grades for a group of students Effort goes from A - D Achievement goes from A* - U the spreadsheet is set out ART - ACH - BIO - ACH I want to be able to count separately the number of grades each pupil has for their effort or...

I am using a 2003 MS Access database to store information from employees regarding health and safety issues. I am currently sending out a paper form, this is returned and I am filling in the data. As all employees I need to contact are using Outlook, (2003), is there a way to send out the form...

I want to compare a date with today's date and if the month is greater to put a Yes in a text box, if not no. I have tried the Iff function and DateDiff but I don't seem to be getting the syntax correct. Any help gratefully received. Cath

I have placed the code in the AfterUpdate, OnChange properties for Question4a and in the Current for the form but it is still not working. I have set the original properties of the comboboxes 4b and 4c to .enabled = false Thanks for your help. Cath

I have a form that is being used as a survey. I have a set the properties of one of the combo boxes to .enabled = false. I want the If an option button is selected the corresponding combobox should be enabled. It works the first time the form is opened but will not update if a different...

I have placed a button on a subform that goes to the next record. This works well, but you then have to click in the textbox (tabstop1) before you can enter the data. Is there a way to automatically have the first tab stop selected. Many thanks Cath