How to Make a Calendar in Excel that Reveals a Picture - Tutorial 📆
Excel tutorial on how to create a calendar using Excel that reveals a picture in the background as the date changes.
In this example, we walk through creating a month calendar and then:
Formatting the dates on the calendar
Inserting an image to be gradually revealed as the day changes and
Creating conditional formatting rules to reveal the image as each day goes by.
The 2 Conditional Formatting rules used are:
1. Unshade any cell with a value between 0 and =TODAY()
2. Unshade any cell where this formula is true: =TODAY()"Insert Greater Than symbol"=11/28/2017 - please replace the text in the quotes with the Greater Than symbol. YouTube does not allow the use of that symbol in the description. Also, don't forget to update with your own date.
You could use a reveal calendar to create a fun, exciting way to countdown to a special event such as a graduation, birthday, vacation, Christmas, NYE, first day of school and other holidays and events!
For more Excel tutorials related to how this reveal calendar was created take a look at these -
How to Create a Month Calendar in Excel in which you can type notes and appointments - Tutorial: • How to Create a Month Calendar in Exc...
How to Format a Calendar in Excel - Tutorial: • How to Format a Calendar in Excel - T...
How to Add a Printable Background Picture in Excel - Tutorial: • How to Add a Printable Background Pic...
How to Use Highlight Cells Rules in Excel Conditional Formatting -
Tutorial: • How to Use Highlight Cells Rules in E...
and
If you're interested in how to calculate time in Excel, watch -
How to Calculate Time in Excel - Add Time and Subtract Time in Excel - Tutorial: • How to Calculate Time in Excel / Add ...
And, If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
