Exact or Vookup?

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!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
All I did for this was to format column E to red text and input the formula, you do not really need the column D formula


Excel Workbook
ABCDE
314.345614.3456TRUE 
465.745667.5678FALSE67.5678
545.946745.9467TRUE 
636.937536.9375TRUE 
712.5914.52FALSE14.52
823.9523.95TRUE 
Sheet1
 
Upvote 0

Forum statistics

Threads
1,224,566
Messages
6,179,555
Members
452,928
Latest member
101blockchains

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top