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
____________________
Do you ever use check boxes on your Excel worksheets? They’re handy for choosing options, or marking completed items in a To Do list.
If you get pivot table refresh errors, this video shows how to troubleshoot those errors and try to fix them. For example, one common error is, “The PivotTable field name is not valid”. Or, you might see this error: “PivotTable report cannot overlap another PivotTable report.”
Sometimes it’s easy to make an Excel chart, and sometimes a struggle. There are days when you feel like a superhero, if you just manage to build a simple chart, and change the colours in it! Here are a couple of short videos that show how to work with Excel pie charts, and win the…
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________
To highlight cells with a value that is too high or too low, you can use Excel Conditional Formatting. This short video shows you the steps. For detailed instructions see Excel Conditional Formatting Basics. ________________
Sometimes a VLOOKUP formula returns an #N/A error, even though you can see the value you’re looking for in the lookup table. The most common cause for this is a text “number” in one place, and a real number in the other place. See how you can fix that VLOOKUP problem.