Question

Before selecting conditional formatting we first _ the cells that have to be formatted​

Answer 1

Explanation:

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100. When the value of the cell meets the format condition, the format you select is applied to the cell. If the value of the cell does not meet the format condition, the cell's default formatting is used. (By "default formatting", I mean the formatting that you set up using the normal formatting tools, not necessarily the worksheet's default font and font size.)

A cell can have up to 3 format conditions, each with its own formats, in addition to the default value of "no formatting". This allows you to have different formats depending on the value of the cell. For example, if the value was greater than 200, you can display the text in red, but if the value is between 100 and 200, display the text in green.

Remember that Conditional Formatting is the same as adding one or more formulas to each cell in which you use it, so applying Conditional Formatting to a large number of cells may cause performance degradations. Use caution when applying to to large ranges.

Simple Conditional Formatting

The simplest Conditional Formatting uses the Cell Value Is option in the CF dialog box, and uses one of the preset comparison operations. This CF Dialog for Excel2000 is shown below.