I have two very large Excel spreadsheets. One is the original sheet, and the other is the output of my application I am writing, which seems to be changing cell values. I'd like to see if there is a pattern to how it is changing them.
I have copied the output spreadsheet into the original a few columns to the right of the original data. What I would like to do is create a formula to change the cell background color if the value in the output data is not the same as the input data.
I have found this guide online which shows a way to apply a rule to edit, from what I can tell, all cells' background values in some manner. But in the Excel dialogue "Create new rule" you can make one based on a formula, though this formula applies to all cells.
What I need is a formula where I can compare the current cell value to another cell value, and change the background color accordingly. I can then apply it to each column in the output data, drag down, and I should be able to see the altercations my software has made.