Group items tagged

Ermenegildo, aka Gildo: wedding photographer, Cinematographer, Wedding Officiant, Speaks English and French. Louise: Second wedding photographer and Cinematographer, Wedding Officiant, Speaks English French, and Italian. We strive to make your wedding the greatest experience it can be, by sharing with you our passion and know-how about photography and weddings. It's all about capturing precious moments that will become treasured heirlooms. We take pride in what we put into your day and, as a couple ourselves, we truly enjoy building a trusting relationship with every bride and groom. It would be a great pleasure for us to document your wedding, whether in our hometown of Montreal or at your destination, or why not both? Please contact us, we would be happy to meet with you in person or via Skype.

Auf Design-Nagel.com erfahrt Ihr alle Trends und Tipps rund um das Thema Nageldesign - French Nails, American, u.v.m. Immer voll im Trend liegen!

This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays. THE BASICS OF CONDITIONAL FORMATTING FOR DATES To find conditional formatting for dates, go to Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. www.office.com/setup You can select the following date options, ranging from yesterday to next month: www.office.com/setup These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule. Below are step-by-step instructions for a few of my favorite conditional formats for dates. HIGHLIGHTING WEEKENDS When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting: www.office.com/setup To change the color of the weekends, open the menu Conditional Formatting > New Rule www.office.com/setup In the next dialog box, select the menu Use a formula to determine which cell to format. www.office.com/setup In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ