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

A successful and effective project management relies on clear communication, organized tracking, and the ability to quickly identify potential roadblocks. While there is no shortage of project ...

For instance, you can use conditional formatting to highlight cells in red if their values fall below a certain number or use another color for values above a target. It can also be applied to ...

Last month, we used conditional formatting to highlight holidays in a matrix-style calendar; we added this enhancement to an earlier article that used conditional formatting to highlight weekends. By ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Excel conditional formatting made easy! Learn formulas, advanced techniques, and troubleshooting tips to enhance your data analysis skills.

Please note: This item is from our archives and was published in 2020. It is provided for historical reference. The content may be out of date and links may no longer function. Conditional formatting ...

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

Click the Home tab. Click the Conditional Formatting dropdown in the Styles group and choose New Rule. From the Select A Rule Type list, choose Use A Formula To Determine Which Cells To Format.

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.