Skip to main content

Conditional Formatting in Row

  • November 26, 2022
  • 6 replies
  • 107 views

Forum|alt.badge.img+4

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

Forum|alt.badge.img+13
  • Inspiring
  • 44 replies
  • November 26, 2022

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 :


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • November 26, 2022

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
Forum|alt.badge.img+33
  • Brainy
  • 8801 replies
  • November 26, 2022

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 


Forum|alt.badge.img+13
  • Inspiring
  • 44 replies
  • November 26, 2022

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


Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • 7 replies
  • November 26, 2022

Thank you all for this!!!


Forum|alt.badge.img+2
  • New Participant
  • 2 replies
  • April 7, 2024

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?


Reply