Hey friends,
I'm stumped. I have a Pivot Table that I'm looking to format but I can't seem to set up a rule without Excel's constraints over-writing my formula. Here's the situation: I have two companies and several customers. For both companies, I have Revenue and Margin data for two years. I'm summing the two companies together for both years and calculating the margin for the combined companies simultaneously. Still, I am also looking to conditionally format the data to show if either company's Revenue or Margin has decreased from the prior year.
Below is a screenshot of the data which I hope helps to paint the picture. In this instance, Company 2's Revenue is less in 2024 than in 2023, so I'd like it to be formatted. Any suggestions?
I'm stumped. I have a Pivot Table that I'm looking to format but I can't seem to set up a rule without Excel's constraints over-writing my formula. Here's the situation: I have two companies and several customers. For both companies, I have Revenue and Margin data for two years. I'm summing the two companies together for both years and calculating the margin for the combined companies simultaneously. Still, I am also looking to conditionally format the data to show if either company's Revenue or Margin has decreased from the prior year.
Below is a screenshot of the data which I hope helps to paint the picture. In this instance, Company 2's Revenue is less in 2024 than in 2023, so I'd like it to be formatted. Any suggestions?
