Results 1 to 2 of 2

Thread: Conditional formatting for dates

  1. #1

    Conditional formatting for dates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to be able to cause a cell B3 to turn red if it is a later date than B2. I also want to be able to turn cell B4 red if it is more than 10 working days later than cell B2.

    Is there a way of doing this?

    Your help really appreciated!

    L

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    323
    Articles
    0
    in the conditional formatting for B3 you can use "Formula Is" and enter =B3>B2 and in b4 you could do the same but =B4>B2+10
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Posting Permissions

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