Results 1 to 2 of 2

Thread: Conditional Formatting Issue with a FORMULA

  1. #1
    Neophyte MikeExcel's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    2003

    Conditional Formatting Issue with a FORMULA



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

    I put this code into Conditional Formatting


    Date(2019,6,19) < TODAY()
    and if true change font colour....it is true and the contents of the cell should change colour



    I put this same code into a cell and it came back TRUE


    Why doesn't it work???

    I tried rewriting the code as follows:
    TODAY() > DATE(2019,6,19) and it worked and then it didn't and does not work now

    PLEASE HELP!!! SO frustrating



    Excel 2003


    Thanks

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    166
    Articles
    0
    Excel Version
    2019

Posting Permissions

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