You will need
  • - Microsoft Excel
Instruction
1
Start office Excel, part of Microsoft Office, and open the menu "Format cells" the top toolbar of the program window to perform the operation of changing the format of the selected cells.
2
Click on the tab "Number" dialog box and specify the desired format in the drop-down list in the section "Numeric formats" (the default format "General").
3
Select the cell you want to change format, and click "Conditional formatting," "Format menu" top tools panel of the application window.
4
Use the parameter Value to perform the operation desired formatting of a cell depending on its contents and specify the comparison operation.
5
Enter a value or a formula (using the " = " symbol) in front of it) or enter the value "Formula" to apply the selected formatting criteria.
6
Enter the value of the formula with logical definitions of "TRUE" or "FALSE" and return to menu "Format" of the top toolbar of the application window.
7
Specify the type of format cells and click the "Add" button to apply the changes.
8
Make the selection of cellsto be copied conditional format, click "Format painter" the top toolbar of the Excel application window for the procedure to copy the format of selected cells.
9
Specify cellsto be changed format and click "Apply" to execute the command.
10
Use the command "Format" to change each criterion formatting you want to change, or select "Clear" in the dialog box "Format cells" for the following definition of the formatting criteria.
11
Press the "Clear" button and specify the required formats.
12
Use the Delete command to conduct cleanup operations selected conditional formatting rules and apply the flags on the sidelines of the criteria to be deleted.