cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
donaldm Regular Visitor
Regular Visitor

How to highlight/bold row when condition is met

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?

1 ACCEPTED SOLUTION

Accepted Solutions
nirvana_moksh Established Member
Established Member

Re: How to highlight/bold row when condition is met

@donaldm - 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.
1 REPLY 1
nirvana_moksh Established Member
Established Member

Re: How to highlight/bold row when condition is met

@donaldm - 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.