Dear friends, I have tabla1 and table2. Ther...

(Etwo Cargo) #1

Dear friends,

I have tabla1 and table2. There is same Columns on both tables like name of client. How can i do this? I want to have name painted as red color if the name is not inside of table2 in name column.

(Bellave Jayaram) #2

Try this for the formatting rule: NOT(IN([Client], SELECT(table2[Client], TRUE)))

(Etwo Cargo) #3

@Bellave_Jayaram Thanks a lot my friend. It is working.