Conditional Formatting

[Groadie65456]

Hi! Newbie here. How do I use conditional formatting to format a cell in a intersecting cell based on a match between a column value and a row value?
Something like this:

 

[Groadie65456]

I just figured it out.

 

[Peter_SSs]

Welcome to the MrExcel board!

We cannot see your row numbers or column letters but try to adapt this.

23 06 29.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2			0	1	2	3	4	5	6	7	8	9	10	11	12	13	14
3
4		2
5		8
6		5
7		7
8		2
9		4
CF Match

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:Q9	Expression	=$B4=C$2	text	NO

 

[Peter_SSs]

I just figured it out.

Yes, that will work, but you can see from mine that you do not need the IF or the TRUE/FALSE