Execution of the procedure for changing the format of a cell of a worksheet of the office application Excel included in the Microsoft Office package refers to the standard operations of the program and can be carried out by regular means without the involvement of additional software.
Necessary
Microsoft Excel
Instructions
Step 1
Start the Excel office application included in the Microsoft Office package and open the "Format cells" menu of the top toolbar of the program window to perform the operation of changing the format of the selected cell.
Step 2
Go to the "Number" tab of the dialog box that opens and specify the required format in the drop-down list of the "Number formats" section (by default, the "General" format is used).
Step 3
Specify the cell to be formatted and go to the "Conditional Formatting" item of the "Format" menu in the upper toolbar of the application window.
Step 4
Use the Value option to format the cell you want based on its contents and specify the comparison operation.
Step 5
Enter the desired value or formula (using the "=" symbol) in front of it) or enter the "Formula" value to apply the selected formatting criteria.
Step 6
Enter the value of the formula with the logical definitions "TRUE" or "FALSE" and return to the "Format" menu in the top toolbar of the application window.
Step 7
Specify the selected type of cell format and click the "Add" button to apply the changes made.
Step 8
Select the cell to be copied in the conditional format, and click the "Format by Sample" button on the top toolbar of the Excel application window to copy the format of the selected cell.
Step 9
Specify the cells to be formatted and click the "Apply" button to execute the command.
Step 10
Use the Format command to change each formatting criterion you want to change, or click Clear in the Format Cells dialog box to further define the formatting criteria.
Step 11
Click the "Clear" button and specify the required formats.
Step 12
Use the "Delete" command to clear the selected formatting conditions and apply the check boxes to the fields of the criteria to be deleted.
