Analysis Newbie
New Member
- Joined
- May 8, 2010
- Messages
- 7
I have two columns of data. Each cell in each column contains numerical costs. Each cell in both columns should match exactly. When the cells don't match, I would like to highlight the cell in column C that doesn't match the cell in column B next to it and put that cell information in a new column and highlight it. I am using Excel 2007.
I can easily write the Exact formula, and show the TRUE, FALSE data in column D but I am not sure how to highlight the False Data and show the figure in yet another column.
For example this is what I would like to do:
<table border="0" cellpadding="0" cellspacing="0" width="320"><col style="width:48pt" span="5" width="64"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" height="17" width="64">Item</td> <td style="width:48pt" width="64">This Cost </td> <td style="width:48pt" width="64">That Cost</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">A</td> <td align="right">123.7956</td> <td align="right">123.7956</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">B</td> <td align="right">14.3456</td> <td align="right">14.3456</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">C</td> <td align="right">65.7456</td> <td align="right">67.5678</td> <td align="center">FALSE</td> <td class="xl22" align="right">67.5678</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">D</td> <td align="right">45.9467</td> <td align="right">45.9467</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">E</td> <td align="right">36.9375</td> <td align="right">36.9375</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">F</td> <td align="right">12.59</td> <td align="right">14.52</td> <td align="center">FALSE</td> <td class="xl22" align="right">14.52</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">G</td> <td align="right">23.95</td> <td align="right">23.95</td> <td align="center">TRUE</td> <td>
</td> </tr> </tbody></table>
Any help would be greatly appreciated!
I can easily write the Exact formula, and show the TRUE, FALSE data in column D but I am not sure how to highlight the False Data and show the figure in yet another column.
For example this is what I would like to do:
<table border="0" cellpadding="0" cellspacing="0" width="320"><col style="width:48pt" span="5" width="64"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" height="17" width="64">Item</td> <td style="width:48pt" width="64">This Cost </td> <td style="width:48pt" width="64">That Cost</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">A</td> <td align="right">123.7956</td> <td align="right">123.7956</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">B</td> <td align="right">14.3456</td> <td align="right">14.3456</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">C</td> <td align="right">65.7456</td> <td align="right">67.5678</td> <td align="center">FALSE</td> <td class="xl22" align="right">67.5678</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">D</td> <td align="right">45.9467</td> <td align="right">45.9467</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">E</td> <td align="right">36.9375</td> <td align="right">36.9375</td> <td align="center">TRUE</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">F</td> <td align="right">12.59</td> <td align="right">14.52</td> <td align="center">FALSE</td> <td class="xl22" align="right">14.52</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">G</td> <td align="right">23.95</td> <td align="right">23.95</td> <td align="center">TRUE</td> <td>
</td> </tr> </tbody></table>
Any help would be greatly appreciated!