+ Reply to Thread
Results 1 to 5 of 5

How to have conditional format highlight cell based on two cell values?

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010
    Posts
    233

    How to have conditional format highlight cell based on two cell values?

    Hi everyone

    I have a workbook that I would like for the cell to be red if the month found in range A22:A24 equals any of the months found in range A8:A19 and they equal to "Fail" which is in column "D".

    Please Login or Register  to view this content.
    but it's not working.
    Attached Files Attached Files
    Last edited by AccountingJ; 07-13-2020 at 02:53 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    592

    Re: How to have conditional format highlight cell based on two cell values?

    use
    =And(Countif($A$8:$A$19,$B22)>0,$D8="Fail")

  3. #3
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010
    Posts
    233

    Re: How to have conditional format highlight cell based on two cell values?

    It's close, I changed the $b22 to $a22 and it marks red except, it marks June instead of May.

  4. #4
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    592

    Re: How to have conditional format highlight cell based on two cell values?

    =VLookup($A22,$A$8:$D$19,4,False)="Fail"

  5. #5
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010
    Posts
    233

    Re: How to have conditional format highlight cell based on two cell values?

    Thank you CrimeDog, that did it.

+ 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. Replies: 6
    Last Post: 11-20-2018, 05:38 PM
  2. [SOLVED] Conditional format formula based on two cell values
    By V.Cell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2016, 11:38 AM
  3. Replies: 8
    Last Post: 06-27-2015, 03:21 PM
  4. [SOLVED] Conditional Format of cells based on other cell values
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-18-2015, 01:02 PM
  5. Conditional Formatting to highlight cell based on values in a string
    By thrst2no in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2015, 09:23 AM
  6. [SOLVED] Conditional Format - Highlight Month Column Based on Cell value
    By pauldaddyadams in forum Excel General
    Replies: 2
    Last Post: 08-06-2014, 06:36 AM
  7. [SOLVED] Conditional Format to highlight cell based on corresponding date..
    By Vikestand in forum Excel General
    Replies: 4
    Last Post: 07-24-2013, 10:48 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