Hello!
I am working on spreadsheet/pivot table and my colleauges want some conditional formatting put in. I already set it up to turn red when a number is 0. In my spreadsheet, i have the numbers for all the weeks i need, and then i have the max number from that customer and the avg # of sales for that customers. I was wondering if there was a way to conditionally format all the cells in the table to highlight based on their respective avg # without going and doing each customer individually. We have a lot of customers and I dont want to do each one individually.
Let me know if this makes sense or if you are able to help me!
Thank you,
Maddie Groezinger
