How to highlight/bold row when condition is met

[Anonymous]

I have a table called Table1, and another table called Table2.

Table1 has all the data; Table2 has one column only, with same column header as one of the columns in Table1

I want to Highlight or Bold if Table1, Column A has the same entry as the data in Table2, how do I do this?

[nirvana_moksh · Accepted solution]

@Anonymous - You can start with creating a new column using the LOOKUPVALUE function to first determine if the value of Table 1. Column A has a corresponding value or not. Based on that result you can use Conditional Formatting options and define rules and change the background color and font color, but there is no way to bold rows.