Results 1 to 2 of 2

Thread: Conditional Formatting Formula

  1. #1

    Conditional Formatting Formula



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

    Hi All,

    I have a spread sheet where Column P has a date in it, I want to be able to highlight that column if the date is 14 days or more.

    Example:

    Column P: 17/07/12
    Becasue it is now past 14 days from Column P it would be highlighted Yellow.

    Can any one tell me the formula.

    Thanks

    Shazz
    xx

  2. #2
    Use a cell value of less than a value of TODAY()-14

Posting Permissions

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