How to highlight cell which is not matched from another sheet

[Liju144]

HI,
I need to match two sheets values in certain range (a1:zz1000) Sheet1 and sheet2 if the sheet one and sheet two value is not matching by then I have to highlight the values where not matching in sheet2

It would be a great support and am same expecting the same

Thanks
Liju

[nilem]

Hi Liju144,
maybe something like this

Please Login or Register  to view this content.

[PCI]

Have a look on conditional formatting.
Is the cells to compare at the same address?