You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using 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 ...

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

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

You can have Excel make a spreadsheet in read only format for others, so that people can read its contents but not edit them, or you can enforce other content restrictions.

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...