The Journal

Google Sheets: Using Custom Formulas in Conditional Formatting

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...
The Journal

Google Apps: Applying Conditional Formatting Across Sheets

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...
TechRepublic

Conditional formatting tricks: Sum values in Excel by cell color

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...

Crush productivity with this $50 MS Office lifetime license + tutorial

TL;DR: Get Microsoft Office Pro 2021 for Windows — plus a full training bundle — for a one-time payment of just $49.99. If ...
TechRepublic

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

How to add visual insight to data by applying conditional formatting to a table or matrix visualization in Microsoft Power BI Your email has been sent Designers often use table and matrix ...