# Conditional formatting **URL:** \ **Category:** Feature Requests\ **Created:** [November 18, 2019, 6:12am UTC](https://community.glideapps.com/t/conditional-formatting/2101 "2019-11-18T06:12:15Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Michael](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael/32/1517_2.png) [@Michael](https://community.glideapps.com/u/Michael)\ **Post date:** [November 18, 2019, 6:12am UTC](https://community.glideapps.com/t/conditional-formatting/2101/1 "2019-11-18T06:12:15Z")
I know that Glide is pretty stiff on design, and doesn’t give the freedom to the user/developer to break design guidelines, but one thing cruelly missing is conditional formatting, where for example we could make some text red or bold upon some alerting condition. That gives an annoying advantage to viewing our data in Google Sheets where this feature exists. ---
**Author:** ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)\ **Post date:** [November 18, 2019, 9:00am UTC](https://community.glideapps.com/t/conditional-formatting/2101/2 "2019-11-18T09:00:20Z")
Hi Michael, There are some (bit time intensive) ways around this that work OK at the moment. I’ve been playing around with it in on of my projects. Since the component Rich Text supports markdown, you can: - use IF() functions for the conditional part - use markdown supported formatting for the formating part. You can (even if not entirely advised atm) also use some html for further formatting. Hope this helps! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 18, 2019, 2:37pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/3 "2019-11-18T14:37:07Z")
Could you give us some context on what the data in your app is, and what the alerting conditions are? Maybe a screenshot of your spreadsheet? ---
**Author:** ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)\ **Post date:** [November 18, 2019, 3:35pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/4 "2019-11-18T15:35:19Z")
Agree, @Michael, conditional formatting would be great to have. I haven’t found a possibility to use colors in markdown syntax as @Karim suggested, only bold or italic. So I added in Data Editor a new _“if-then-else”_ relation column, where I added colored emoticons (to code noun gender). ![image0%20(2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/590f03e19f5aad53cf648a67d3042a6430119489.jpeg) ---
**Author:** ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)\ **Post date:** [November 18, 2019, 5:11pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/5 "2019-11-18T17:11:34Z")
Hi Natalia, This helped me a lot in figuring it out. You need to use some HTML synthax: > ---
**Author:** ![Michael](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael/32/1517_2.png) [@Michael](https://community.glideapps.com/u/Michael)\ **Post date:** [November 18, 2019, 5:18pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/6 "2019-11-18T17:18:28Z")
@Mark Sure… See a screenshot of my app (pardon my Hebrew 🙂) What you see here is an inline list of budget lines, and I want to color the items with negative values with a red font, for example. The solution I chose in the meanwhile are those traffic light images… ![shlita_cat_list](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/40a1372a409e7bdaea8cb0234381fc4cc29709a0.png) If you look at the sheet for example, the background colors for alerting cells are relatively more communicative. ![shlita_cat_list_sheet](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/af03c1cac29f318fc7f82fcf534cae6f9abdae87.png) ---
**Author:** ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)\ **Post date:** [November 18, 2019, 5:59pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/7 "2019-11-18T17:59:04Z")
Thanks, Karim, just tried it and it works 👍 ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 19, 2019, 10:17pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/8 "2019-11-19T22:17:09Z")
@Karim and @NataliaGo . Just a warning that Glide does not recommend using HTML as part of the Rich Text component as they may in the future not support it. I suspect that they are giving that warning because whatever markdown interpreter/implementation (not sure if that is the technical term for it) they use may drop support for it for security reasons. Even the link that Karim shows eludes to that. _**"Now, StackOverflow (and probably GitHub) will strip the raw HTML out (as a security measure) so you lose the color here, but it should work on any standard Markdown implementation."**_ ---
**Author:** ![Michael](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael/32/1517_2.png) [@Michael](https://community.glideapps.com/u/Michael)\ **Post date:** [November 19, 2019, 10:21pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/9 "2019-11-19T22:21:34Z")
Does it also support markdown in custom template columns ? And eventually in list items using values from such custom columns ? Well I tried and my **words** remained with asterisks… ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 19, 2019, 10:29pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/10 "2019-11-19T22:29:44Z")
Sure it does. You just need to use it in a Rich Text component. It’s a bad example below but the column Approved was used in the Template and as you can see it is bold in the Rich Text component that I added as the last component. ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9bf661756d9e6c67f8f3c2fe53f9199420bba688.jpeg) ---
**Author:** ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)\ **Post date:** [November 19, 2019, 10:34pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/11 "2019-11-19T22:34:57Z")
Yes, thanks @George_B, I’ve read it, so decided to stay with my Rich Text Format column idea. At least for this specific case. But it was fun to try it once for my other app:laughing: ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 19, 2019, 10:37pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/12 "2019-11-19T22:37:53Z")
@Michael Sorry I missed the part of your question about list items showing markdown. In that case no, they don’t support markdown. ---
**Author:** ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)\ **Post date:** [November 19, 2019, 11:10pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/13 "2019-11-19T23:10:56Z")
@Michael @George_B that’s why I think emoticons are a way to go, maybe it will not always be appropriate and relevant, but you can add ❌✖✅↗↘ various signals in the column with if-then.-else. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 19, 2019, 11:38pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/14 "2019-11-19T23:38:26Z")
@NataliaGo Agreed. ---
**Author:** ![Michael](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael/32/1517_2.png) [@Michael](https://community.glideapps.com/u/Michael)\ **Post date:** [November 20, 2019, 6:18am UTC](https://community.glideapps.com/t/conditional-formatting/2101/15 "2019-11-20T06:18:48Z")
@NataliaGo Yes that’s what I’ve been doing too, with custom images ---
**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\ **Post date:** [June 24, 2021, 12:24pm UTC](https://community.glideapps.com/t/conditional-formatting/2101/16 "2021-06-24T12:24:12Z")
when can we expect this feature, already requested in nov. 2019 ?