Condition Formatting in Pivot Table?

How can I condition format cells in a pivot table with:

If the row has a cell (A1) with 'Dog Food', then the profit percentage (D1) should be conditional formatted with those criteria:
Green: The Sales (C1) is higher than Cost (B1) AND the profit percentage (D1) is higher than 50%.
Yellow: The Sales (C1) is higher than Cost (B1) AND the profit percentage (D1) is lower than 50%.
Red: The Sales (C1) is lower than Cost (B1) AND the profit percentage (D1) is lower than 50%.

I have several different groups the above criteria would apply the same but each group has different profit percentage:
1) Dog food (50%)
2) Cat food (45%)
3) Grooming (70%)
So on...

I have tried to think of a formula by using IF statement... AND statement... I am to no avail. -.- How may I write formulas for each criteria to condition format the profit percentage cell for each group? Keep in mind this is for a pivot table so it is likely to change and be updated. Is this possible?

Many thanks!

Perhaps this link will get you started

Put this formula in CF
GREEN: if(and(c1>b1,d1>50))
Yellow: if(and(c1>b1,d1<50))
RED: if(and(c1<b1,d1<50))

If not solved plz post a sample file

Try This

Green: The Sales (D1) is higher than Cost (C1) AND the profit percentage (E1) is higher than 50%.

Formula:

=AND(D14>C14,E14>INDEX($L$7:$N$24,MATCH($B14,$N$7:$N$24,0),1))

Yellow: The Sales (D1) is higher than Cost (C1) AND the profit percentage (E1) is lower than 50%.

Formula:

=AND(D14>C14,E14<INDEX($L$7:$N$24,MATCH($B14,$N$7:$N$24,0),2))

Red: The Sales (D1) is lower than Cost (C1) AND the profit percentage (E1) is lower than 50%.

Formula:

=AND(D14<C14,E14<INDEX($L$7:$N$24,MATCH($B14,$N$7:$N$24,0),2))