+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting ... Today() & More

  1. #1
    Ken
    Guest

    Conditional Formatting ... Today() & More

    Excel 2000 ... What I have

    Col T ... contains values ... 0 & 1
    Col AA ... contains dates ... mm/dd/yy

    In Col AR I wish Conditional Formatting Formula for when
    condition is:

    Col T = 1
    Col AA = date older than 3 years from Today.

    Thanks ... Kha

  2. #2
    JE McGimpsey
    Guest

    Re: Conditional Formatting ... Today() & More

    one way:

    CF1: Formula is =AND(T1=1, DATEDIF(AA1+1,TODAY(),"y")>=3)


    In article <105b01c50eb3$d3176db0$a601280a@phx.gbl>,
    "Ken" <anonymous@discussions.microsoft.com> wrote:

    > Excel 2000 ... What I have
    >
    > Col T ... contains values ... 0 & 1
    > Col AA ... contains dates ... mm/dd/yy
    >
    > In Col AR I wish Conditional Formatting Formula for when
    > condition is:
    >
    > Col T = 1
    > Col AA = date older than 3 years from Today.
    >
    > Thanks ... Kha


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1