Tag Archives: conditional formatting

Microsoft Excel – comparing two columns using conditional formatting

Due to data entry issues, a client had instances where she had the same information for some records in both the Address2 and the Town column. She wanted a quick way of seeing where this was happening. Information stored in … Continue reading

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

Microsoft Excel – creating a calendar with weekends greyed out

I was demonstrating using the fill handle to create lists of weekdays recently when one of my trainees asked whether we could instead produce a calendar with weekends greyed out. The answer is to use conditional formatting. I first of … Continue reading

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

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 – Conditionally format blank cells

To conditionally format blank cells: Select the data range that you want to format. From the Home tab, click the Conditional Formatting dropdown and click New Rule. Click Use a formula to decide what cells to format. In the Format … Continue reading

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

Microsoft Excel – Conditionally format blank cells

To conditionally format blank cells: Select the data range that you want to format. From the Home tab, click the Conditional Formatting dropdown and click New Rule. Click Use a formula to decide what cells to format. In the Format … Continue reading

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

Microsoft Excel – Using conditional formatting to highlight the minimum number on each row

Someone on a recent Excel course said that he had been looking at comparing prices from different suppliers for different products and wanted to find minimum prices for each product and highlight them. This can be done using conditional formatting … Continue reading

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

Microsoft Excel – comparing two columns of figures using conditional formatting

Suppose I have sales figures for two years and I want to highlight this year’s figures in green if they are higher than last year’s figures and in red if they are lower than last year’s figures. Select the figures … Continue reading

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

Microsoft Excel – copying conditional formatting to other cells

If you have created conditional formatting in one cell, you can copy that formatting to other cells using the Format Painter. Click in the cell containing the conditional formatting, then on the Home tab, in the Clipboard group, click Format … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , | 1 Comment

Using Conditional Formatting to find duplicate data in Microsoft Excel

If you have duplicate data in a workbook, it is good to be able to see what that duplicate data is, before deciding whether or not to delete it. In Microsoft Excel versions 2007 onwards, conditional formatting can be used … Continue reading

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

Conditionally formatting a row based on the value in one cell in Microsoft Excel

If we have a worksheet where we want to format a row based on the value in a cell, for example, we want to highlight all rows where the invoice date is more than 30 days old. In this case … Continue reading

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