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?
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.
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.
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.