Format as table in google sheets


How to highlight or conditional formatting the max or min value in Google sheet? Normally, you can quickly highlight the largest or smallest value by using Conditional Formatting in Microsoft Excel. But, you may not find a similar feature in Google sheet. Formatting text and numbers. The ability to apply specific formatting for text and numbers is one of the most powerful tools in Google Sheets. Instead of displaying all cell content in exactly the same way, you can use formatting to change the appearance of dates, times, decimals, percentages (%), currency ($), and much more. Table Styles provides you with a set of style templates for your tables in Google Sheets. You can quickly select and apply the style, edit it, or create a new one. You can quickly select and apply the style, edit it, or create a new one. However I am guessing scripts won't retain the formatting? Do any of you have an idea on how to do this? I guess I need HTML? But how would I create a script to do this? For excel, I get it to take a screenshot and attach it to an email. However I am hoping there is a much easier way for google sheets. The table can have zebra lines meaning alternating rows are formatted with different colors (see example). Google Sheets do not support zebra stripes (yet) but you can use conditional formatting combined with a simple Google Formula to create a formatted table. You can apply alternating colors to both rows and columns in Google Sheets easily.