Microsoft Office Tutorials and References
In Depth Information
Use Conditional Formatting
Figure 18-7:
Auditing
formulas.
Use Conditional Formatting
Just like the IF function returns a certain value when the first argument
condition is true and another value when it’s false, conditional formatting lets you
apply a certain format to a cell when a condition is true. On the Home tab in
the Styles section is a drop-down with many conditional formatting options.
Figure 18-8 shows some values that have been treated with conditional
formatting. Conditional Formatting lets you set the condition and select the
format that is applied when the condition is met. For example, you could
specify that the cell be displayed in bold italics when the value it contains is
greater than 100.
Figure 18-8:
Applying a
format when
a condition
is met.
Search JabSto ::




Custom Search