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.![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
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.
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)