# Google sheet Formula and Formatting

**URL:** https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035
**Category:** Ask for Help
**Created:** [March 28, 2020, 7:11pm UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035 "2020-03-28T19:11:34Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 2, 2020, 1:41am UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035/4 "2020-04-02T01:41:49Z")

</div>

There are several posts and a quick google search shows how to do html. Again, Glide advises against using html in a rich text component since it can stop working at any time. Just be prepared if html stops being recognized in the app. I’m sure some day Glide will give us the option to adjust coloring, but for now this is the only option. There are limited options with markdown in the rich text component as well as the new Text component

> [@Salon Beauty/ Barber Shop app💈](https://community.glideapps.com/t/salon-beauty-barber-shop-app/4314):
>
> Hey hey, Gliders! First topic here! I’ve been using and abusing glide all over my days for months. And to open this topic, I wanna introduce you my new brand Salon Beauty/ Barber Shop app! barber What will you see here? Circle Profile Image using Rich Text (not tiles); Screens and Font Color totally personalized by the theme and for each person. And much more. Let’s take a look. I made two apps for Salon Beauty/ Barber Shop app! barber: Admin Clients Adminiphone point_right [htt…](https://sallonadmintemplate.glideapp.io)

> [@Google Sheet does not match data view in Glide](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/20):
>
> The logo is just an image with a lot of empty space on the left. It functions as a button to take the user to an “About” screen. “CHALLENGE PERIOD” is just a Glide Basic Text component. I fiddled around to determine the color and size of the header font (color: #666666; font-weight: 400; font-size: 0.857em;) so I could mimic it in the table. The table itself was a lot of trial and error in Markdown. Here’s the formula in the cell: ="\<span style='color: #666666; font-weight: 400; font-size:…

> [@Simple idea of showing a customer message](https://community.glideapps.com/t/simple-idea-of-showing-a-customer-message/891):
>
> I had a simple idea of displaying a message to the customer, I used the HTML code to display the message, it can be typed directly into the cell or the way I did using the new column template options. \<html\>\<h1\>\<marquee\>\<font color="#F5D0A9"\>Horário de atendimento das 08:00AM as 06:00PM\</font\>\</marquee\>\<h1\>\</html\> Sample Application: [https://2oxda.glideapp.io](https://2oxda.glideapp.io)

---

_[View the full topic](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035)._