Search results

Thanks Faseeh That is just what I need. I knew there was a way to do it. I should learn to program in excel. Just find it hard to get my head around the logic of it. Thanks for your assistance. It is much appreciated. Sue

Hi Faseeh I have uploaded the file. I have put comments in the excel chart to try to answer your questions. Let me know if you need further explanation. The chart I have uploaded is only for seven months, however, the project is to run for four years - so this is why I need a bit of...

Hi Faseeh Thanks for your response. I have not been able to get back here til now. The weekday+5 was when I was using the file which there were problems with. I will upload another file with an example. It will take a little while as I have to create it. I will also put in an example...

I have removed the file from the google drive link - so this link no longer works. The link to the file is https://www.dropbox.com/s/4xeh5coplhgeht6/Gantt%20Chart%20revised.xlsx Again - any assistance greatly appreciated. Thanks in advance Sue

Hi Faseeh The dropbox link - with a new Gantt chart from the original is at https://www.dropbox.com/s/4xeh5coplhgeht6/Gantt%20Chart%20revised.xlsx Thanks for any assistance Sue

Hi Faseeh I recollect that I downloaded the original from Chandoo, and have amended it a few times. I know that sometimes when I open it it gives a warning not to use it - but not sure why - I had forgotten about that. Thanks and apologies for the potentially corrupted file. I have the...

Does anyone have any suggestions for this question? Thanks for any suggestions

I am doing a Gantt chart - and I need it to be in weeks - not days, as this project is over a period of 4 years. I have modified the dates to be workday+5 - I am sure there is a better way of doing this - but my knowledge of programming is not good enough to work this out. One of the tasks...

Thanks Narayan. I thought it was something like that - had not analysed it sufficiently to pick up that subtle difference. Will make the alterations. Thanks again - and for the instructions - most helpful. That's why you're a NINJA and I'm a member (pupil in my books! - especially in formula...

Thanks again Narayan . If you look at the original, where the weight has decreased from one month to the next, the % change was show as a negative number. I notice with the last update you did, this has occurred for a few of the months but not all. It would be better if this feature could be...

Thanks Narayan - that was it. Will look at the formulas in the cells so I can do similarly in the future. Much appreciated. Sue

Congratualtions Faseeh. Great asset to this community.

I have a weight chart for a health care organisation and cannot figure one part of conditional formatting. In the previous % weight gain or loss column (the document can be seen at https://docs.google.com/open?id=0BwL-nA3ga6NVUUN5UjJocEJKOUE ) I need to highlight if there is a weight gain or...

Thanks GeorgeF211. Will try it and see if I can get it to go. Will not have an opportunity to do this til the weekend.

Thanks GeorgeF211 wasn't sure whether to do that or not. I have put the document on https://www.dropbox.com/s/6k207p0n4xj1zfa/Incident%20report%20August.xls - this is what I got from the client - it hasn't been amended other than to change the names in the cells. The cells I need highlighted...

I need to use conditional formatting in a spreadsheet a client is using. Unfortunately they only have Excel 2003. What I have is four different areas, lets say for ease of explanation, A, B, C, D and E and a range for each month of about 30 or 40 incidents. There can be any number in each of...

Thanks Hui. I realised (after everything became coloured) the error I had made. I have tried the formula you gave me and it works brilliantly. Thanks for your assistance.

If I have conditional formatting and it is if any cell is less than say 90, (providing there is a number in the cell) how can I do this? When there is nothing in the cell, it is also highlighted but that is not what I want. I can't get my head in the right place to get this, and know it should...

Thanks Narayan. I got it to work at last. Thanks for your patience. Sue

Hi Narayan Thanks for the response. I am still struggling with this for some reason. Each time I try to change =$N$5 to =$N5 it automatically reverts to =$N$5 when I click apply. Also you say to copy the format to all other cells. How do I do that? as when I am in a cell there is no...

I had thought that what I had done would sole the issue - but it didn't. When I went to a row further down, the average had been based on the first row. Later today I will update the document to show what I mean. In the interim, if anyone has any easy method of doing this, can you let me...

After thinking this through and trying a few things, I found the answer - thanks.

I need to apply conditional formatting for averages for a group of hospitals. There are 82 questions and each hospital supplies their results and the average for each question is calculated. I thought that there is possibly a way to apply a conditional format to highlight if the individual...

I just found another possible issue. If F8 is pressed, it turns on/off "Extend selection". I just tried this and it does extend the selection - so that is possibly the issue. Have suggested to my colleague and will put here if it works. Thanks Jazzkid

Thanks Prsad DN. I will suggest this to my colleague and let you know how it goes. Regards Jazzkid