Excel University: Microsoft Excel Training for CPAs and Accounting Professionals: Volume 1: Featuring Excel 2016 for Windows by Jeff Lenning

Author:Jeff Lenning [Lenning, Jeff]
Language: eng
Format: azw3
Published: 2017-03-20T04:00:00+00:00

XREF

Setting up custom rules is discussed in Volume 4, Chapter 16.

Apply Two Additional Rules

In this chapter we are temporarily limited to using only the built-in shortcut rules and will simply apply two additional Conditional Formatting rules: one rule to format the cell red when the value is greater than zero, and another rule to format the cell red when the value is less than zero.

This is done in two steps. First, highlight the cell and then select the following Ribbon icon:

•Home > Conditional Formatting > Cell Value Rules > Greater Than

Use the Greater Than dialog to format the cell red when the value is greater than zero. Next, apply an additional rule by selecting the following Ribbon Icon:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.