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.