I have column A and Column B, how to highlight the cell when they are equal?
Sample and Expected Result
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Apple[/TD]
[TD]Banana[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Banana[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Apple[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Banana[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I tried to do this by doing Conditional Formatting, it works, however my rows are dynamic and blank cells bottom down after the last row with value are also captured.
Thanks.
Sample and Expected Result
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Apple[/TD]
[TD]Banana[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Banana[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Apple[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Banana[/TD]
[TD]Apple[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I tried to do this by doing Conditional Formatting, it works, however my rows are dynamic and blank cells bottom down after the last row with value are also captured.
Thanks.
