I use colored fields and text in Excel to denote progress of an order. For example:
Each line in my spreadsheet represents a customer’s order, with the most recent orders added to the bottom. Columns represent stages of design & manufacture. As each part of the design process is completed (ex: the customer approves a design proof), the date it happened is entered into the column. We want to color-code a field based on whether it’s been requested, is in-progress, or has been completed. We can’t use color-coded drop-down options because the content of the field is going to be a unique date.
Also, we submit batches of orders for manufacturing on a weekly basis. The “Dye-Sub Purchase Order Submitted” column (the content is a date) is then colored either light blue or light pink, with each weekly batch alternating colors so they’re very easy to pick out visually. (last week’s batch was pink, this week is blue, next week will be pink, etc.) That’s important, as we deal with entire batches from that point forward, not individual orders.
Basically, we just need the ability to color-code individual cells at will. It seems a very simple feature to incorporate, and strikes me as the type of thing that would have been available in the earliest versions of this software. Honestly, I’m testing other similar pieces of software right now only because I can’t color-code cells in Airtable.
Likewise, we should be able to color text, and have access to really basic formatting options, like boldface. I know this isn’t Excel, but those sorts of things are really, really commonly used by pretty much everyone who uses a spreadsheet for anything beyond calculations. People who use Airtable want it to behave like a spreadsheet.