format.xls

<div>
<div class="content wysiwyg-content">
Hey guys,<br />
<br />
I have been fiddling around with Excel for ages now and cannot do what seems to be a simple task.<br />
<br />
I have two rows of data which I want to compare. If the information matches I want the cell in the 2nd row to turn green, if the information doesn't match I want the cell to turn red.<br />
<br />
Thus for the data below, F1&amp;F2 should be red and F3:F9 should be green.<br />
<br />
&nbsp; <a href="https://filedb.experts-exchange.com/incoming/2011/02_w08/410112/1.JPG" target="_blank" title="Data (9 KB)"><img alt="Data" class="file-block lazyload" style="max-width: 64px;" data-src="https://filedb.experts-exchange.com/incoming/2011/02_w08/410112/1.JPG" /></a><br />
Can someone please help me out.<br />
Cheers<br />
G_M
</div>
</div>


1.JPG

Hey guys,

I have been fiddling around with Excel for ages now and cannot do what seems to be a simple task.

I have two rows of data which I want to compare. If the information matches I want the cell in the 2nd row to turn green, if the information doesn't match I want the cell to turn red.

Thus for the data below, F1&F2 should be red and F3:F9 should be green.

  

Can someone please help me out.
Cheers
G_M

Conditional Formatting - Compare two rows respectively

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.