[Solved] Change Cell color if Same Value Exists in Another Column

[rkwynn.73]

Hello I am trying to come up with a way to change Cell color if Same Value Exists in Another Column.
Example: Column B has a list of names which include (Ray), Column C (Random names) and Column D has a list of names which also include (Ray), So I am trying to change the Cell color if Same Value Exists in Another Column, is that possible with the IF and Vlookup function?

[Zizi64]

You can colorize/highlight a cell based on some condition by the Conditional Format feature.

You can use the cell fuctions for the condition: MATCH(), VLOOKUP(), etc... If you want to colorize more than one cell, then you need combine the relative and the absolute references in the condition.

Please upload your ODF type sample file here.

[rkwynn.73]

Sample.png (36.2 KiB) Viewed 1135 times

So what I'm going for is, if a text value shows up in both columns B and D, change the cell color to blue, if a text value shows up in columns B, D an E, change the cell color to blue. if a text value shows up in columns B and E change the cell color to Red. Would this be possible to do? I am fairly new to writing formulas using IF(), MATCH(), VLOOKUP(), etc...

[Zizi64]

It is not an ODF file...

[Villeroy]

t108973.ods

(15.49 KiB) Downloaded 122 times