Compare Multiple Excel Cells with Conditional Formatting
In 5 minutes the secret of comparing multiple #Excel cells with conditional formatting will be revealed!
The tricky part is to select the range of cells to be conditionally formatted and then to write the following formula "=A1='Sheet1'!A1". The A1 should be the first cell to be formatted, e.g. upper left.
Seems simple once you know it.
