Search results for query: *

=AND($H2="",$F2=1,$O2="Open") tried it just in cell 2, but it only Applied the formatting to cell 2 so i highighted the whole row and entered the value and thats when i giot the results above Tim

sorry to be a pain, I have applied what you said (i think i have done it correctly) however the result is not correct, I have filtred on cells with a red colour and the ones that are red are cells without a 1 in F and one with a value in H Tim

sorry still struggling I am highlighting all of column H, then going to the conditional formatting option and then choose new rule and then use a formula to determine which cells to format and then i enter the below, this does nothing =formulais(AND($H$2="",$F$2=1,$O$2="Open"))

Hi Geoff Thanks for your response, however where is the formula is option?, and how do I enter it for all rows?

Hi i would like to format column H of my worksheet with a RED colour if the cell is blanc, however I also only wish to format it if column F has a value of 1 in it how can this be done? tim

It will be each morning, so yes it will be unique and will be the one with yesterdays time stamp

I have got it to copy the 2 files and add the date stamp onto the new ones, great.... How do I move the two original files to a different location? set timestamp=%DATE% set timestamp=%timestamp:/=-% copy aviva*ppsx Aviva Programme Daily Defect Statistics %timestamp%.ppsx copy aviva*pptx Aviva...

Hi I have tried - cd\users\timw\desktop\trinity local\trinity\projects\admin re\development\alpha\stats and trend This works ok copy aviva*.ppsx This fails saying cannot find file specified

Hi I have two files which I require a batch command to carry out the following: 1) Copy both files 2) Move to orignal files 3) Rename to copied files a) File location is users\timw\desktop\trinity local\trinity\projects\admin re\aviva\development\alpha\stats and trend b) files to be copied...

: I have just had a new Acer Desktop PC, it came with a free trial of Macafee Yesterday I decided to uninstall macafee and put my own symantec on, however as macafee was uninstalling the PC shutdown, when it came back up the internet connection only gets a local connection I have tried to reboot...

Hi I have got Norton Ghost 10.0 and Windows Vista When I try and define a new backup I get the following errors in order 1) Cannot retrieve Drive Properties 2) Cannot rescan disks -Info 6C8F1C25: Cannot rescan disks. --Cannot successfully reconcile changes since last session. ---Cannot...

Hi there We have just upgraded from 5.5 to 2003, since then we have experienced 3 issues 1) A lower amount of incoming emails, usually each person would get around 100 emails over night, they are now getting between 4 and 15, this is really low as to usual, not sure where they might be going...

We have recently migrated to exchange 2003, I would like to set up OWA but it only works internally It seems as though I have to make the server a front end server, but it doesnt allow me to do it on this server Can anyone help? Thanks Tim

SELECT Applicants.FIRST_NAME as Apllicant_First_Name, Applicants.LAST_NAME as Apllicant_Last_Name, Companies.NAME as Company_Name, CVsSent.DATE_SENT as CV_Date_Sent, Requirements.JOB_TITLE, Interviews.DATE_TIME as Interview_Date, Employees.USER_NAME as Employee_User_Name, Interviews.NUM as...

Thanks ca8msm Can you show me how you would add the getdate() function and to return data for the past 30 days? Tim

This is the query, I need to run this automatically I want it to get todays date then pull back the data for the past 30 days up to todays date SELECT Applicants.FIRST_NAME as Apllicant_First_Name, Applicants.LAST_NAME as Apllicant_Last_Name, Companies.NAME as Company_Name, CVsSent.DATE_SENT as...

I am trying to run a query where it looks for todays date and then brings back date for the past 30 days Can any one help? Thanks Tim

hi guys i have tried both the above and the query runs but it is still running now it is too big as it is across different tables and has a lot of data, how can i speed it up? Tim

Hi I have wrote the following query but i get the error "Syntax error converting datetime from character string." use itrisdb1 select employees.user_name, companies.name, cvssent.date_sent, requirements.job_title, interviews.date_time, applicants.first_name, applicants.last_name...