Results 1 to 2 of 2

Conditional Formats with same criteria evaluate differently (one as TRUE, other as FALSE)

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2021
    Location
    Earth
    MS-Off Ver
    Excel 2019 (Build 14430.20234)
    Posts
    1

    Conditional Formats with same criteria evaluate differently (one as TRUE, other as FALSE)

    Attachments
    # Image attached

    Background Context
    The table has the following (relevant) columns:

    COLUMN B: Weeks (TEXT, 7 rows merged at a time)
    COLUMN C: Day (NUMBER, increases from 0)
    COLUMN D: Weekday (TEXT, converting the WEEKDAY of the adjacent Date)
    COLUMN E: Date (DATE, formatted as "dd-mmm-yy)

    I am trying to create a format for the Weeks (Col. B) column, but ran into issues and began to troubleshoot an already used conditional format. It is used in the Day (Col. C) and Date (Col. E) columns, and works fine.

    Input
    The conditional format:

    $E4=TODAY()
    I confirmed in separate cells that the value of TODAY() and the current value in column E are the same, and yield the same serial number.

    Error
    However, when I use the same formula from the working conditional format to a different column with test data, the condition does not evaluate as TRUE.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. TRUE / FALSE multiple criteria
    By MattKoleczko in forum Excel General
    Replies: 7
    Last Post: 01-06-2020, 11:39 PM
  2. True/False for Multiple conditions and formats in a range of cells
    By Vatoemperor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2015, 03:51 PM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. [SOLVED] True & false - range criteria
    By jani.pk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2014, 12:21 PM
  5. [SOLVED] Multiple TRUE,FALSE criteria
    By quibilty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2013, 11:47 PM
  6. Excel 2007 : IF/AND TRUE/FALSE and two criteria
    By myparticulars in forum Excel General
    Replies: 11
    Last Post: 08-20-2009, 04:23 PM
  7. Adv Filter criteria, true false, vs 1 and 0
    By Larryr8732 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2007, 12:02 PM

Tags for this Thread

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