Conditional Formatting in Row

[Jason_Eskin]

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?

[Soly]

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 :

support.airtable.com

Record Coloring by Conditions | Airtable Support

Coloring records based on conditions allows you to define rules, and any record that meets those rules will automatically receive the...

[kuovonne]

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]

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]

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

[Jason_Eskin]

Thank you all for this!!!

[gennaria]

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?