Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post

    Post Change the color of the cell after specific duration.

    Hi Experts

    I am looking for VBA code which will change the color of the cell on the following condition.

    Say If a user adds a date 10/2/2015 in a cell of a column and till next 7 working days the user is allowed to change the change the date, but after 7 working days if he/she change try to change the date, the cell color gets changed.

    Regards,
    JD

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi Jaggi

    Welcome to the Lounge.

    See attached workbook.
    This attached example will do what you ask.

    Please try it and come back if you need further help.

    zeddy
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Zeddy

    Thanks for the code.

    Regards,
    JD

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •