Excel Conditional Formatting Update
The holidays are a great time to catch up on tasks. I’ve updated another popular Excel video — Colour a Row Based on a Cell Value in Excel 2007. It now explains the steps in Excel 2010 and Excel 2007, instead of Excel 2003.
To continue the conditional formatting theme, here are a few articles that you might have missed, when they were originally posted.
- Highlight Weekend Dates in Excel – To make it easier to keep track of weekends in Excel, you can use conditional formatting to highlight the rows where the date is a Saturday or Sunday.
- Excel Conditional Formatting – Data Bars – In Excel 2007 and Excel 2010, you can use conditional formatting to add data bars to cells. This makes it easy to visually compare the list of numbers, just as you would in a bar chart.
- Highlight Lottery Numbers with Conditional Formatting – If you win the big draw, you’ll be sure to notice, if you use Excel to highlight the winning numbers.
Note: This is the last day to vote for the Excel functions that you’d like to learn more about during the 30 Excel Functions in 30 Days challenge, starting January 2nd.
Watch the Conditional Formatting Video
If you haven’t moved to Excel 2007 or Excel 2010, here’s how to colour a row based on a cell value in Excel 2010 or Excel 2007.
Video Link: Colour a Row in Excel Based on One Cell’s Value http://www.youtube.com/watch?v=kd4g8t81co0