Select two items from the drop down lists, to colour the valentine dark pink.

Select one item from the drop down lists, to colour the valentine light pink.The Excel Valentine heart has white fill and white font, so it’s not visible. On a Mac, another key combination might be needed. Tip: To type a heart shape, press Alt and type a 3 on the number keypad (if no number keypad, try Fn+Alt+L). Add a bottom border to each merged cell, with red or dark pink border colour.Ĭreate the following data validation drop down lists:.Tip: After you merge E1:I1, drag the Fill Handle, to copy the formatting down to the next two rows.Merge cells E1:I1, E2:I2, E3:I3 (yes, merging can cause problems, but it’s allowed on Valentine’s Day).To prepare the cells for the drop down lists: Next, you’ll create three drop downs, for the Valentine message at the top of the worksheet. Format the cells with white fill and font.The heart shape will be hidden, and only revealed when the Valentine message is selected.

With the Heart range still selected, set up the following conditional formatting: Type the following formula, then press Ctrl+Enter, to enter the formula in all the selected cells:.The formula will count how many text items have been added at the top of the worksheet, and the result is used for conditional formatting.

Select the coloured cells, and name the range as Heart.

Then, add red fill colour to cells in rows 5:14, to create a heart shape.

Start by making columns A:M narrower, to create square cells.

If you won’t have time, or if your drawing skills are worse than mine, you can download the sample Excel Valentine file, at the end of this blog post.Īnd if you want some romantic music in the background, while you work on your Excel Valentine card, you can listen to the YouTube playlist, compiled by John Walkenbach and his blog readers. Your boss won’t mind if you spend a couple of hours working on this today, because it’s an Excel project! This Excel Valentine card uses a named range, data validation, a formula, and conditional formatting (to change the heart from white to pink to red). Yes, it’s Valentine’s Day today, and if you were too busy to buy your sweetie a card yesterday, you can make one in Excel.

How to plot a graph in excel mac 2011