We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

6] Click OK in the New Formatting Rule window to apply the conditional formatting to the selected rows and columns. This will highlight the rows with dates before today’s date.

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets users format cells based on certain conditions, including the date contained in a cell and how far away that ...

Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets users format cells based on certain conditions, including the date contained in a cell and how far away that ...

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 ...

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.