• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Date reminders/alerts

    TessaES thank you so much. Working perfectly. Thank you to all for the help. Coriolis
  2. C

    Date reminders/alerts

    tessaES, thanks for the help, however excel throws an error at me when i try your code?
  3. C

    Date reminders/alerts

    Thanks again to everyone, I have it working using the formula =D5<=NOW()-7 and the range is set to =$D$5:$D$1000 How would i make it ignore blank cells? i only want it to format cells with a date entered. Thanks again
  4. C

    Date reminders/alerts

    Hey everyone, thanks for the help. oldchippy, how would i use your formula to format a whole column, from lets say, c4 to infinity? Ill have a go at making it work myself in the meantime. Thanks
  5. C

    Date reminders/alerts

    Hi, Im working on a spreadsheet for my employer. Its a record of all his quotes and sales. He has a column where he records the date he last contacted each client and want excel to change the colour of the cell after a set amount of time if he hasn't updated that cell. For example, if he...
Back
Top