Using pivot table data for conditional formatting?

Using pivot table data for conditional formatting?

Hi!

I want to be able to create a sales report that shows a weekly average of incoming sales.  I have that report, (sales by week, total as average) but would love to be able to highlight customers whose incoming sales are below that average percent.  Is that possible, and I can provide more info if needed.