I have a relatively large pivot table. Can I do a conditional
formatting of cells so that if cell font changes color based on
conditions

e.g. I have a pivot table that lists Monthly sales by product

Report is like this
Page level -Region,Promotion

Horizontal --- Months

Vertical -- Products

If I want to compare the latest months sales over last month if more
then make it green if less make it red, If I change the pivot
condition at the top it should automatically adjust the colors

Also can I compare the pivot table cells to Mean, Median etc for a
quarter, year

Thanks