Forum Discussion

DingoDigits's avatar
DingoDigits
Copper Contributor
Mar 11, 2021
Solved

Excel Conditional Formatting to highlight Matches/Non matches with different colors

Hello, I have two columns - Column A has unsorted items that may include one or more blank lines in between each item  - Column B is a sorted list of items that 'should' be present in the first col...
excel
Formulas and Functions
Macros and VBA
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 11, 2021

    DingoDigits 

    You may use

    Red:
=NOT(SUM(COUNTIF(B2,A$2:A$200)))

Green:
=SUM(COUNTIF(B2,A$2:A$200))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 11, 2021

DingoDigits 

You may use

Red:
=NOT(SUM(COUNTIF(B2,A$2:A$200)))

Green:
=SUM(COUNTIF(B2,A$2:A$200))

Resources