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