How did I make Google Sheets and Excel automatically highlight the current date in a list?

I needed to create a spreadsheet that had a sequence of 150 dates across 150 columns.

But when you look at a long list of dates, it can be hard to find the current one. So I decided to make the current date highlighted.

How did I do that? I’ll show you first in Google Sheets, then in the Windows edition of Excel, then in the Mac edition of Excel.

Between the Sheets, Episode 82.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,

Get in touch

AI Workshop Inquiry/Booking