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.