=INDIRECT(ADDRESS(ROW(),COLUMN()))<>OFFSET(INDIRECT("<name of sheet>!A1"),ROW()-1,COLUMN()-1,1,1)
Asumes comparison starts from A1 cell.
Built using: https://productforums.google.com/forum/#!topic/docs/GfSEU3ngRvo
Created
October 12, 2018 16:49
-
-
Save yoelrc88/60807a49af9a3147d4c3d91188ab43de to your computer and use it in GitHub Desktop.
Formula to conditionally format comparing two sheets in a Google Sheet cell by cell.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment