3 ms·
How to identify and format common entries across Google Sheets?
I need help trying to figure out how to -
1 - Compare sub-sheets in a Google Spreadsheet with a master sheet in the Google Spreadsheet
Ex. Sheet A = master-sheet, Sheet B = sub-sheet.
-Compare the values in a column of cells in Sheet B to the values in a column of cells in Sheet A
2 - Identify cells in the sub-sheet column that also appear in the master sheet column
-If a value "X" appears in the column of numbers in Sheet A appears in the column of numbers in Sheet B, identify that cell in Sheet B
3 - Color the cell in the sub-sheet to the same color of the row in the master sheet
-If the cell with "X" in Sheet A is yellow, change the color of the cell with "X" in Sheet B to yellow
Thanks!