Search code examples
google-sheetsgoogle-sheets-formulaconditional-formatting

Conditional formatting of a range based on another range in google sheet

I want to have conditional formatting for sheet1 (Columns A-E) in such a way so that cell values which match with the values present in sheet2 (Column A) should be highlighted in red.

I am sharing this example output sheet for your reference.

Please help me out, if it is possible please.

Solution

  • Use this conditional formatting custom formula rule:

    =countif(indirect("sheet2!A2:A"), A2)

    See your sample spreadsheet.