What I want to do is compare all of my results against what the server generated and highlight the cells that don't match. I've manually calculated and generated expected output from this same set of input to compare against what the server is generating.

Based on input data into our server, we expect certain output from the server. How do I use conditional formatting to highlight a cell in one column based on the value of another cell in another column?Ĭase in point, I'm running some tests right now.