Conditional Format Pivot Table based on first column Values

[StrawberryDreams]

Hi there I am working on a pivot table that highlights cells based on a Min. Value. However I would like the ability to color code the conditional formatting based on the product which is listed in the first column... apple, turnip, carrot etc. Make apple red, carrot orange etc.

On a side note I originally created custom number formatting to the Row column table. After a row number is entered the format will add a "Row " in front of the number. This also happens for the Bay column. When I created the pivot table it added these words which is great, but I modified the custom number format to display "row " , instead of "Row ". After I changed the formatting to display lowercase the pivot table does not refresh with that change and continues to display the Capital R. Any ideas why ?

thanks for you help

Map.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1								MIN	3
2	Bay	Row	Post	Product	Level	Week		Sum of Level	Post
3	Bay 2	row 12	10	apple	3	17		Bay / Row	4	8	10	18	Grand Total
4	Bay 2	row 12	8	turnip	4	17		Bay 2
5	Bay 5	row 5	18	apple	2	17		Row 12
6	Bay 12	row 12	10	carrot	3	17		apple			3		3
7	Bay 16	row 8	4	apple	5	17		turnip		4			4
8	Bay 12	row 4	4	carrot	2	17		Bay 5
9								Row 5
10								apple				2	2
11								Bay 12
12								Row 12
13								carrot			3		3
14								Row 4
15								carrot	2				2
16								Bay 16
17								Row 8
18								apple	5				5
19								Grand Total	7	4	6	2	19
20
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I6:L7,I10:L10,I13:L13,I15:L15,I18:L18	Cell Value	>=$I$1	text	NO

 

[StrawberryDreams]

Is this an index/match or search type formula ?