• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Validation check(Solved)

U

uul

Member
Hi all,

I have a spreadsheet where on tab 1 is a pivot and tab two is a grand total of that pivot. What i am looking for is a formula that looks on the pivot to see grand total and then cross check it against the grand total on tab 2, and if its the same highlight it in green, if not then red. The issue is tab 1 is a pivot so the cell i need to check could be different week on week
 
You can do so with the help of a helper cell. As can be seen in the attached sheet, I have cell O7 as a helper cell.
 

Attachments

  • Conditional formating.xlsx
    14 KB · Views: 3
When you say Pivot is it a Pivot Table?

As if it is you can automatically add a Grand Total to the PT
Select any cell in the PT,
Right Click
Add Grand Total
 
You must log in or register to reply here.
Back
Top