Monthly Archives: July 2015

Microsoft Excel – conditional formatting on combination of two words

I often demonstrate how to conditionally format based on looking for particular text in a cell, but what if two (or more) words have to be in the text string. In the example below, I want to show cars that … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , | Leave a comment

Microsoft Excel – finding all birthdays within a particular month

If you have a column containing dates of births, it is easy to find all birthdays falling within a particular month by filtering the data. To do so, either format the dataset as a table – Home tab, Styles group, … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment