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.
________________
In an Excel pivot table, you can use built-in custom calculations, for a different view of the data. For example, in this video I set up the pivot table to show what % of monthly sales were Binders, and what % for each colour – red, blue, and black. You can get the sample file…
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?
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data. For written instructions please read…
You can create a user form in Excel, to control how users are able to enter data. These 3 short Excel video tutorials show you the steps. For detailed instructions please visit the web page Create an Excel UserForm. _________________
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.”
When you open a file in Excel, you might see an "Enable or Disable a Macro” message, but you know that there are no macros in the file. Follow the steps in this video, to prevent this message from appearing. For written instructions see: Remove Excel macro warning ______________