Conditional formatting in excel is used to format the cell as per the stated condition or conditions. In excel you can also create your own rules to format a cell. In the below example, we will highlight the cell as orange and will bold it for the student marks that are above 70.
In order to achieve the above objective, follow the below steps:
Step 1: Select Cells range C3:C10
Step 2: Click on the home tab, click on conditional formatting, from the first option (highlight cell rules) and then select the option “Greater than”. Screen shot provided below for your guidance.
Once you performed the above steps, you will see a screen like the one below.
Step 3: Write 70 under the headings “Format Cells that are GREATER THAN” and select “Custom Format” from the list as shown in the above image.
Step 4: When you select the “Custom Format” option in the above step, a new screen will open as below.
From the “Fill” option select “Orange” color and from the “Font” option select “Bold” Style and click OK on both the screens. The final output is exactly the same as we wanted it to be at the start.
You can download the excel file by clicking here