Conditional Formatting - comparing data in Pivot Table

Hello,

I have 2 data sets in a Pivot Table - STOCK and SALES. I want to set a conditional formatting saying that if SALES are higher than STOCK the "SALES" cell color should be red.

I attached the pivot table as well as the end state that I need.

Thanks a lot!!

If it needs to be via a macro - totally fine.

i think you can just do it as if cell value is greater than whichever cell you want as i believe after excel 97 that should still work even after refresh(cant test as i have '97 but i see you have 2007)