![]() ![]() ![]() The idea behind conditional formatting is simple: You want to be able to look at a table or a range of data and quickly see any values that demand your immediate attention or spot trends that might not be apparent from the raw data. In this section, we explain how to take full advantage of it. We introduced this feature briefly at the beginning of this chapter, in the discussion of the Quick Analysis tool. You can help your audience (and yourself) make more sense of data by using conditional formatting to highlight values that meet criteria you define. Are there ways to highlight trends and patterns and identify anomalies while still maintaining a full view of the data in a table? Indeed there are. Tables filled with data can be overwhelming and difficult to understand without lengthy explanations. Using conditional formatting to highlight cells based on their content
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |