As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1731716
Conditional Formatting
Closed

Comments

  • Garrett Reed started the conversation

    Hello. I am pretty sure I will be buying your product. Your g sheet integration seems to work perfectly.

     That said, I have a question regarding conditional formatting. I know you can set greater than / less than / equal to values for color in a column. 

    Unfortunately, the Google  sheets I will be using are dynamic and change throughout the day with values being very different. Setting > ,<,=  values for color formatting won't work for me here. The highest values in my columns/cells one day may be from 80000-10000, while the next day the top values in those same cells/columns may only be 600-700. What should be green formatting one day  will essentially be formatted yellow or red the next because the daily variance in the highest and lowest numbers in the column .  This is no good.

    Is there a workaround in conditional formatting that will allow me %, or  percentile color formatting or rank color formatting so that the top numbers or percentile will always be green, middle yellow, lower red, etc?

    Thank you in advance for your help. 


  • [deleted] replied

    Hi Garrett,
    Thank you for your inquire. 

    Unfortunately there is no such an option with conditional formatting at this moment. Maybe you could use one more column in g sheet to calculate necessary percentage and apply conditional formatting on that column to apply color on whole row.