+ Reply to Thread
Results 1 to 3 of 3

Conditionally format pivot table results based on high and low targets

  1. #1
    Registered User
    Join Date
    01-28-2021
    Location
    Florida
    MS-Off Ver
    2012
    Posts
    2

    Conditionally format pivot table results based on high and low targets

    I have attached a copy of the Excel file I am working with. I want to conditionally format the pivot table on the Crop Dashboard so that if the pH or EC numbers listed are higher than the high targets listed on the Crop Target tab they are one color (blue), if they are lower than the low targets they are another color (red), and if they are between or equal to the low and high targets they are either white or no color change.

    I get the basics of how to conditionally format, but I'm just not sure what formulas to use to compare the results in the pivot table to the Crop Data high and low targets.

    I'm still a relative newbie at working with pivot tables and charts, so go slow, lol! Thank you!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    55

    Re: Conditionally format pivot table results based on high and low targets

    Hi

    you did good, just the formula was wrong. Compared the wrong column in Vlookup with the wrong value in the table itself

    should be fine now
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-28-2021
    Location
    Florida
    MS-Off Ver
    2012
    Posts
    2

    Re: Conditionally format pivot table results based on high and low targets

    You rock! Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to conditionally format pivot table
    By jlblackburn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2020, 03:38 PM
  2. Pivot table with Sales and targets
    By bryanmcguire in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-19-2018, 10:22 AM
  3. Looking for VBA to conditionally format Pivot Table under each Row Label
    By CVinje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2018, 12:56 PM
  4. [SOLVED] Rank items in Pivot table from high to low and low to high based on the filter selected
    By jholiday78 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-19-2017, 11:22 AM
  5. Replies: 1
    Last Post: 01-04-2017, 06:00 PM
  6. Replies: 1
    Last Post: 01-04-2017, 05:59 PM
  7. Conditionally Format a Pivot Table
    By ClikClak in forum Excel General
    Replies: 2
    Last Post: 06-24-2010, 01:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1