Hello,
I am trying to figure out how to use conditional formatting to verify the data set in columns A through F match the data in columns H through M. I have tried setting up rules, and it's worked for everything except when someone accidentally reverses data that is very close. For example, line C3 says 202A on the left side, but says 203B in line J3. Line C4 says 203B, and J4 says 202A. I need this to flag as differing, but with the rules I set up, there is a 202A and 203B on both sides of the data set, so it doesn't see it as a difference. How do I make sure these are flagged as differing using conditional formatting? I can't use If/Then statements, it needs to be something a little easier for the end user I am setting this up for. There is already a very complex macro ahead of this sorting that I don't want to touch, so I'm not sure how to add on another macro to the already processed data, and frankly I don't want to. Is there a way to use conditional formatting to flag these differences? Thank you!!!
[TABLE="class: grid, width: 754, align: left"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]200[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]200[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]201[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]201[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]202A[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]203B[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]203B[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]202A[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]204[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]204[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]205[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]205[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]206[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]206[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]207[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]207[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]208[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]208[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]209[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]209[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]210[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]210[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]211[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]211[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
</tbody>[/TABLE]
I am trying to figure out how to use conditional formatting to verify the data set in columns A through F match the data in columns H through M. I have tried setting up rules, and it's worked for everything except when someone accidentally reverses data that is very close. For example, line C3 says 202A on the left side, but says 203B in line J3. Line C4 says 203B, and J4 says 202A. I need this to flag as differing, but with the rules I set up, there is a 202A and 203B on both sides of the data set, so it doesn't see it as a difference. How do I make sure these are flagged as differing using conditional formatting? I can't use If/Then statements, it needs to be something a little easier for the end user I am setting this up for. There is already a very complex macro ahead of this sorting that I don't want to touch, so I'm not sure how to add on another macro to the already processed data, and frankly I don't want to. Is there a way to use conditional formatting to flag these differences? Thank you!!!
[TABLE="class: grid, width: 754, align: left"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]200[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]200[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]201[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD="align: right"]201[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]202A[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]203B[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]203B[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]WMT[/TD]
[TD]202A[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]204[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]204[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]205[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TGT[/TD]
[TD="align: right"]205[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]206[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]206[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]207[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]207[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]208[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]SBUX[/TD]
[TD="align: right"]208[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]209[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]209[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]210[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]210[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]211[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[TD] [/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]TYCO[/TD]
[TD="align: right"]211[/TD]
[TD]3137865B7[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]32318.45[/TD]
[/TR]
</tbody>[/TABLE]