Changing the font colour in a Cell

[S Walker]

I would like to change the Font Colour of a manually inputed number in Cell C4 Sheet3 from Black to Red if it is equal to any of the Manually inputed numbers in Cells C5 to L5 in Sheet 2.
Many Thanks n advance. SW.

 

[StephenCrump]

Welcome to the Forum!

One way is to use conditional formatting:

	A	B	C
1
2
3
4			22
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4	Expression	=ISNUMBER(MATCH(C4,Sheet2!C5:L5,))	text	NO

	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3
4
5			11	22	33	44	55	66	77	88	99	1010
6
Sheet2

 

[S Walker]

Thankyou Stephen. Looking at this solution it seems clear and obvious but I cannot get my Conditional Formatting menu to show your images. Is there something I'm doing wrong? I am using Office 2019

 

[S Walker]

Sorry. Just tried the formula in the line on my version of CF and it worked! Mant Thanks Again from one Stephen to another.