Recent content by Togora

Hi Gruuuu, I did. Thanks again. Togora Nancy Astor: “Sir, if you were my husband, I would give you poison.” Churchill: “If I were your husband I would take it.” Sir Winston Churchill

Hi Gruuuu, I understand what you mean however, when I copy and pasted in your examples they didn't work as well as my final solution. So my question is, is you suggestion regarding not needing to "target" the range so in every case? Regards Togora Nancy Astor: “Sir, if you were my husband...

Hi SkipVought, Thanks for your response. Your conclusions are what I discovered during testing, the TODAY() function is the way to go. It is also what I have entered into our spreadsheet earlier to day. Regards Togora Nancy Astor: “Sir, if you were my husband, I would give you poison.”...

Hi Gruuu, Many thanks for your submission. It appears your conditional formatting suggestion is the way to go. I have actually arrived at the answer but through a different route. I first derived the following: Green: =ROUND($D2-NOW(),0)<=7 Orange...

Hi SkipVought, Many thanks for the offer however my last post prior to "I GIVE UP!" meets all the requirements and from that NOTHING will change. With that I have no additional information. If you are able to work on that great. If you cannot than thank you again for your effort, extreme...

Hi SkipVought, I thought you might. Well, many thanks for the assistance you provided. Regards Togora Nancy Astor: “Sir, if you were my husband, I would give you poison.” Churchill: “If I were your husband I would take it.” Sir Winston Churchill

Hi SkipVought, You did as I asked and had taken the difference between the "DMD Date" and the "Issue Date". However I should have read the notes I took on this problem. Sorry! What I should have asked for was, as stated in my last post, the DMD Date plus the requisite number of days which...

Hi SkipVought, Sorry if I have wasted your time with this problem. I have not only confused you but also myself. What we are attempting to do is show on a spreadsheet demands which have not arrived on time and by way of colour and date how late the demands are in arriving. Therefore: White =...

Hi SkipVought, Sorry for not getting back sooner here is the sample spreadsheet I use: DMD DATE DMD VOUCHER ISSUE 10-Feb-11 5718 119457 07-Feb-11 27-Mar-11 8686 120963 10-Feb-11 10-Feb-11 10-Apr-11 27-Jan-10 11-Apr-11 07-Feb-11 12-Apr-11 09-Feb-11 13-Apr-11 19-Feb-11 14-Apr-11...

Hi SkipVought, Ok, You are good, but are you great? I plugged in your formulas and they worked, not surprising I think I hear you say. But, there had to be a but. Part of the criteria was between 1-7. The formula colours the row green when it is the same day eg 28/03/11 and 28/03/11 when it...

Hi mintjulep, It is date based therefore you would never get 7.5 days and would be day 8. Thanks again, Togora Nancy Astor: “Sir, if you were my husband, I would give you poison.” Churchill: “If I were your husband I would take it.” Sir Winston Churchill

Hi mintjulep, The criterion is: Equal to or between 1 -> 7 (but not zero) Equal to or between 8 -> 20 Equal to or greater than 21 Then the row requires sorting and finally coloured green, orange or red. I hope this is a little clearer. Thanks for the quick reply though. Nancy Astor: “Sir...

Hi SkipVought, Thank you for highlighting "Red at the top then Orange finally Green." in quotes. I see why you did this, it should have read "Red at the top then Orange and finally Green". My English grammar is slipping, sorry. Togora Nancy Astor: “Sir, if you were my husband, I would...

Hi, I am attempting to sort a list with a date criteria and then dependant on the criteria the row would be coloured. For example: Criterion (in days): 1-7 = Green, 8-21 = Orange and 22+ = Red DMD DATE DMD VOUCHER EXPECTED RECEIPT DATE 27-Jan-11 5718 119457 07-Feb-11 08-Feb-11 8686 120963...

Hi Doug, I carried out your suggestion but to no avail. If Word is unable to "see" Math add-in and is not listed either as a disabled add-in or an active add-in. If I understand it correctly there should be an add-in button added to the ribbon next to the equation button. I wrote an equation...