We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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.