+ Reply to Thread
Results 1 to 2 of 2

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

  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:

    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,174

    Re: Conditional Formats with same criteria evaluate differently (one as TRUE, other as FAL

    Welcome to the forum.

    It would help if you attached a sample Excel workbook, rather than a picture of one, by following the instructions given in the yellow banner at the top of the screen.

    Pete

+ Reply to Thread

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