Page 122 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

Adding Conditional Formatting

Let's say you have a worksheet with thousands of rows of data. It would be extremely difficult to see
patterns and trends just from examining the raw information. Conditional formatting allows you to
automatically apply cell formatting—such as colors, icons, and data bars—to one or more cells based

on the cell value.

Using Find and Replace

When working with a lot of data, it can be difficult and time consuming to locate specific information.
You can easily search your workbook using the Find feature, which also allows you to modify content

using the Replace feature.

113 | P a g e