Hello Mike,

Please go to tutorial: 10.10 Use a formula to determine which cells to format.

I explain how you can do this in this tutorial!

Let me know if you have any questions, I’m here to help 🙂 

Cheers,

John Michaloudis

thanks John

That certainly helped.

Still struggling to apply it to the full Pivot Table without copying and pasting the conditional formatting per column.  Is there a way to show this by column level (eg Actual Coluumn replicated 12 times)

I have months running along as columns with Plan and Actual Values for each month, with product running vertically as rows.

Hope this helps explain further?

Thanks

Hey Mike,

Yes you can!

Hover above a column name for the Actuals and when you see the arrow, left mouse click click and this will select all the Actual columns.

Then go to Home > Conditional Format > New Rule:

Apply Rule To: =$B$5  

Then choose the last option radio button.

Select a Type Rule: Use a formula to determine which cells to format

Edit the Rule Description: =B5>C5 (or the first cell that your actual & plan values are).

Format > Fill > Choose your color > OK.

I have attached the workbook for you.

Note: If your Conditional Format doesn't work the first time, go to Home > Conditional Format > Manage Rules > This Worksheet > Edit Rule.

Then in the Edit The Rule Description, make sure that the formula is =B5>C5

Sometimes this formula changes to B6>C6 which is wrong and needs to be amended.

Let me know if this solution helps.

Cheers,

John