Highlight all the cells in a row, if one cell is above or below a specific value.
To do this, use Excel conditional formatting, as described in this short Excel video tutorial.
For detailed instructions, please visit the page Excel Conditional Formatting Based on another cell
____________________
If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers ______________________
Chandoo started a new Excel series on his blog — How to create a fully interactive Project Dashboard with Excel. In this video for Part 1, Chandoo shows how to set up a Project Gantt Chart, and 3 more lessons in the series are coming.
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter. To remove the duplicates, follow the steps in this short Excel video tutorial. ______________
On TikTok, I follow Bryan Nothling aka thebnoth, because he’s funny, and he’s Canadian! His “working from home” videos have brightened my days, and he has over 200K followers, so I’m not the only person who enjoys them.
In Excel 2003, or earlier versions, you can move the color and border palettes close to the cells you’re formatting. To see the steps, watch this short Excel video tutorial. For written instructions, see the move the color and border palettes in Excel notes on the Contextures website. ______
Did you ever set up your Excel workbook exactly the way you want it, with headings in a freeze pane at the top, and hidden gridlines, and other settings? And then one day, all of those settings disappeared? Why did that happen, and how can you prevent that from happening again?