Pivot Conditional formatting
 

I have a value in a column (value) in pivot - there are two other value
columns, based on the data in the two other columns, I would like to
Conditional format the current column C.

so if column C row 15 = 3
format green if column C column D
format yellow if column C column D and < column E
format Red if column C < column E

two issues arise for me:
1. I am not sure how to keep fill a refrence row by row
2. the pivot changes and I would like to keep this formula consistant,
because the columns average and sum to the correct numbers.

thanks for your help
--
Regards,

Donica