Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel, but many users aren't aware it exists.

Table Setup To get started, select any cell inside your data set, then choose Home > Styles > Format as Table (On a Mac: Tables > Table Styles). A ‘Format as Table’ menu will pop up.

Quip, a startup with mobile apps for crafting and collaborating on documents, has turned on some useful capabilities when it comes to working with spreadsheets.

Microsoft Excel’s RANK.EQ () function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ () with a conditional formatting rule to highlight ...

Conditional formatting is one way to help you monitor metrics and Google just introduced it to its popular dashboard.

Learn how to add visual insight to data by applying conditional formatting to a table or matrix visualization in Microsoft Power BI.

The 2010 version of Access offers an improved format for Web-ready databases, conditionally based macros, customized database themes and conditional formatting within reports. Access is a relational ...