Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formula help (97)

    in A1 I've got a textstring ending with the 2 digit year "04".
    What formula do I need (in conditional formating) to highlight this cell once it becomes out of date (i.e. after 04)?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: formula help (97)

    How about:
    =RIGHT(A1,2)>RIGHT(YEAR(TODAY()),2)

    Steve

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula help (97)

    thanks Steve-
    just needed to swap > for <

Posting Permissions

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