Search results

Thank you for coming back to me. I really appreciate the questions. I understand there is a better way to do this than copy paste and know that Excel and Chandoo has the answers - unfortunately my skills so not match up! I have looked at this...

Hello All, I hope you are each having a wonderful day. I need help, helping a colleague of mine... There is a workbook containing a single worksheet. This form is sent to 250 project managers. They all complete their copy with performance data and emails it to my colleague. All columns...

Hello All, I have had a play with the sample spreadsheet, unfortunately it gives me the same error I had before. HOWEVER I have found an elegant work around, and provide it here in case it helps anyone else. In sheet one, two, three four and five - The user selects 1, 2, 3, 4 or 5 in cell...

Dear Cyril, no need for apologies I appreciate your helping me. Will work out how to upload the w/book just in case. Dear SirJB7, I will add the extra column, perhaps just letting the users type their own actions and then hiding the auto suggestions is a more elegant solution. Dear Faseeh...

Hi Cyril, Thank you for the swift response. It's a good solution but won't work for me as; 1) the if function retuns action planning suggestions based on the response the user give to a series of questions. So if they answer level one in cultural maturity, they get action suggestions that...

Hello All, I have a new quirky issue, which is probably because I am trying to over step my excel skill sets (again). This formula returns action plan suggestoins from another worksheet based on the responses to questions the user selects; =IF(A3=1,'Intervention Admin...

Dear All, First of all thank you for taking the time to help me on this. Second of all, I have tried each of the suggestions and they all work in a fresh workbook. I think I was either adding the group box first and then putting the options into it, or the group box was too skinny and...

Wow - thank you so much for responding! WIll try and come back again asap. I am glad it seems weird to you guys too! Thought was loosing my marbles! Thank you again and fingers crossed! C

- just in case that didn't make much sense; Why are my option (radio)buttons allowing multiple selections in a groupbox? This is happening in both Forms and Controlbox options. Thank you in advance again! Claudine

Hello All, (sorry the spacing isn't working in the post!) I need some help with my radio buttons (option buttons)I have researched some of the issues and am left one problem I cannot seem to get around. I am using Excel 2003. They are not behaving independently. Selecting one, auto selects...

Thank you for this. That's the first part I need. BUT.... If A3 is blank and TODAY()is >= A1 + 22 days then A3 should go Red If A3 is blank and TODAY()is <= A1 + 10 days then A3 should go Green If A3 is blank and TODAY()is between A1+11 days and A1+15 days then A3 should go Amber...

Let me try another way of explaining; A1 1 June 2011 Start Date A2 15 June 2011 Planned Date A3 cell is green if TODAY's date is less than or equal to A1+14 Days and a user has not entered a date in A3 yet A3 if the user enters 15 June 2011 in A3 then I need the...

Wow - thank you for the uber fast response... A1 Start Date A2 Planned Date A3 Actual Date A3 should go Red if A3 is blank and TODAY() is greater than or equal to A1+22 days A3 should go Amber if A3 is blank and TODAY() is between A1+11days and A1+15days A3 should go Green if A3 is blank...

Dear All, I am new to the forums, though not the site (which rocks!) and I really need some help. I have; Start Date in A1 Planned Date in A2 (based on rules on turnaround) Actual Date in A3 (which will remain blank until a user types in a date) I want A3 to change RAG colour using TODAY()...