Conditional Format

[davidvo68]

I wanted to change the field value font in table 1 to a specific color if the same value is also in table 2.

Example: 

Table 1: 123456, 123789, 456789

Table 2: 456789

Thank you in advance for any insight.

[davidvo68]

It worked.  Thank you so much.

[VN999 · Accepted solution]

Create Calcualte Column in Table 1 that checks if each value exists in Table 2.

ExistsInTable2 =
IF(
Table1[Value] IN VALUES(Table2[Value]),
"Yes",
"No"
)

Next set conditional formatting rules:

• If ExistsInTable2 is "Yes":
  • Set the font color to red (or any color you choose).
• If ExistsInTable2 is "No":
  • Leave it as the default color.