Coloring cells based on different values.

[AlexanderHUN]

Hey guys, i have a bit of a problem here solving this issue hope someone can help me out:
So I have a table that looks like this with couple thousand rows more, from time to time i would have to find some of the rows based on the UNIQUE IDs and instead of manually looking for them, I would love to have a formula in Column D where I could just input the Unique IDs im looking for and the formula would highlight all the matching Unique IDs with color in the UNIQUE ID column, so after that I could just filter for color in the UNIQUE ID column and then I would have all the necessary information I need. Thanks in advance.

Input Date	Project Number	UNIQUE ID	IDs Im Looking for	Column D
01.01.2023	ABC90	0001	0002
01.01.2023	ABC90	0002	0004
01.01.2023	ABC90	0003
01.01.2023	ABC90	0004

 

[arthurbr]

Depending on your XL version there are diffrent possibilities. Please update your profile with the version you are using so that the board can give the solution tailored to your version.

 

[AlexanderHUN]

Updated it quickly, Im using the 2016 version.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	Input Date	Project Number	UNIQUE ID	IDs Im Looking for
2	01/01/2023	ABC90	001	002
3	01/01/2023	ABC90	002	004
4	01/01/2023	ABC90	003
5	01/01/2023	ABC90	004
6
7
8
9
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C100	Expression	=COUNTIFS($D$2:$D$10,$C2)	text	NO