Even though you need a format like 02/08/2021, Excel Online and Google Sheets may use something else, like 08-02-2021. At times, you might not like such a change due to a lack of familiarity.

The sheet shown in Figure A is simple on purpose so we can focus on the conditional format that highlights any date that matches the current date. Cell C1 returns the results of the =TODAY() function.

How to create data bars in Excel. 1. Select the cells you want to apply the data bars to. You can select a single cell, a range of cells, a table, or the entire sheet.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.