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!


  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Manchester, England
    Excel Version
    Excel 2016
    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

Posting Permissions

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