Multiple Intersections, Conditional Formating

[bschulze]

I'm looking to apply a cell highlight to all intersections where the row and column heading match. The data set will be a pivot table, but if this prohibits the application of formatting I can work with a table. Solution needs to be Excel 2007 compatible. An example of what I'm looking for below.

Any help would be greatly appreciated, conditional formatting is not my strong suit.

Excel 2007
	A	B	C	D	E	F
2	Type	2	6	8	9	15
3	1
4	2
5	3
6	4
7	5
8	6
9	7
10	8
11	9
Sheet1

 

[bschulze]

Mike, your formula (=($A3=B$2)) will work with the following setting. When setting conditional formatting on a Pivot Table you get three unique options for the "use a formula" option. The third radio button is "All cells showing "Total" values for "X axis" and "Y axis". When this radio is checked the range will automatically be adjusted in the conditional formatting.

Sorry for any confusion, and thank you both for your help.