Excel also allows applying the said formatting rules on user-defined criteria. For example, suppose we need to highlight the cells with dates that are older than 30 days or 60 days.

Now, the dataset will display only rows 1, 4, and 5. Next, you need to highlight the visible rows. In Google Sheets, you may select visible cells by selecting individual ranges.Here’s how: ...

These hidden tools could save you hours. Copy Formatting Repeatedly . Excel's Format Painter tool is an invaluable time-saver, as it lets you duplicate formatting from one cell or object to another.