Question

. Briefly explain conditional formatting? write down the steps to use​

Answer 1

Answer:

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.  

Answer 2

Answer:

The font group on home tab contains a number of ' font formatting options before applying any formatting effect select the cell.