Help

Re: Conditional Formatting in Row

2726 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Eskin
6 - Interface Innovator
6 - Interface Innovator

I think this has been asked before, but I can’t figure out if it was ever answered: Is there any way to do row-based conditional formatting? I.e. is it possible for me to format a row (let’s say, make it all BOLD or add a color to it), depending on the value inside one of the cells/records within the row?

6 Replies 6
Soly
7 - App Architect
7 - App Architect

Hi @Jason_Eskin,

Absolutely, it is possible to add color to the record depending on conditions. This illustrated guide shows you step by step how to apply color conditions to your table :

It is not possible to make text in a row bold based on conditions in a cell.

It is possible to use record coloring. However, record coloring is only a dash of color to the left of the record in the grid view. It does not affect any cell values or the backgrounds of any cells.

ScottWorld
18 - Pluto
18 - Pluto

As others have said above, conditional formatting is (unfortunately) not a part of Airtable.

Be sure to report this as a feature request to support@airtable.com

In the meantime, you can always create a formula field with some colored emojis in it, which can be helpful when quickly scanning through a list of records.

For example, you could have a formula field that results in text that looks like the following:

Canceled
🟡 Overdue
🔵 In Progress
 Completed
🏆Awarded

Also, if you want to pay extra money to get conditional coloring of your records, Noloco’s advanced interfaces for Airtable offers this feature. They call it “highlight coloring”.

p.s. If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Soly
7 - App Architect
7 - App Architect

:thumbs_up: Awesome replies! Thanks for the precision @kuovonne and for the “emojis color” workaround @ScottWorld

Jason_Eskin
6 - Interface Innovator
6 - Interface Innovator

Thank you all for this!!!

gennaria
4 - Data Explorer
4 - Data Explorer

This, like the inability to change the height or wrap text in headers, is one of the inexplicable things about Airtable. I don't care about adding AI, but I would love to have the simple BASIC features that Excel and even Google Sheets have had for years. Is there a place besides this forum to express this frustration to the product team?