Dynamics GP Tip: Excel Conditional Formatting

Understand your results more effectively by using Excel Conditional Formatting:

Excel Conditional Formatting

The Excel Conditional Formatting feature can be used to highlight cells that meet certain criteria.  In this example, item with a Quantity Available less than or equal to zero are highlighted in yellow.

Conditional Formatting can be found on the Home tab.

Excel Conditional Formatting in GP

Use the pre-defined options or choose New Rule to create a custom format.


Leave a Reply

Your email address will not be published. Required fields are marked *

X