Results 1 to 10 of 10

Conditional formatting not matching third criteria

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,465

    Conditional formatting not matching third criteria

    Col A shows the Equipment number, Col B the date rented out and Col C date returned.

    Cols I - S are the dates from 1 - 16 Jan.

    Conditional Formatting formula works perfectly in identifying the "date ranges", but posts them sequentially in the rows matching the dates in Cols A - C.
    =AND($B2<=I$1,$C2>=I$1)

    But when the Equipment is added, it doesn't work:
    =AND($A2=$H2,$B2<=I$1,$C2>=I$1)
    Correct location is shown by thick border around each bloc of cells.

    All solutions, suggestions and recommendations received gratefully as ever,

    Ochimus

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting with multiple/matching criteria.
    By gz3s36 in forum Excel General
    Replies: 7
    Last Post: 09-06-2017, 06:58 AM
  2. Conditional Formatting based on 2 matching criteria
    By mattsonberg in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-11-2016, 12:04 AM
  3. Conditional formatting: not matching
    By akkerstad in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-06-2014, 01:12 PM
  4. [SOLVED] Matching duplicates based on multiple criteria, conditional formatting?
    By Jaqjaq in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-23-2013, 02:42 PM
  5. [SOLVED] Count cells with date criteria matching conditional formatting colour
    By summer2010 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-07-2013, 04:34 AM
  6. Excel 2007 : matching cells with conditional formatting
    By strokedmaro in forum Excel General
    Replies: 2
    Last Post: 06-20-2010, 06:03 PM
  7. Conditional Formatting if Matching Set of Values
    By Niester Rabbit in forum Excel General
    Replies: 10
    Last Post: 06-08-2009, 02:55 AM

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