Answer:
It involves 7 steps, explained below
Explanation:
1st step: Using Excel, select the cells you want to format, for instance A2:A9
2nd step: Go to the Home tab > Styles group and click Conditional Formatting. You will see a number of different formatting rules, including data bars, color scales and icon sets.
3rd step: Since we need to apply new conditional formatting only, we choose the numbers we desire, we choose Highlight Cells Rules < Less than what we want.
4th step: Enter the value in box in the right-hand part of the window under "Format cells that are LESS THAN", in our case we type what we desire. As soon as you have entered the value, Microsoft Excel will highlight the cells in the selected range that meet your condition.
5th step: Select the format you want from the drop-down list. You can choose one of the pre-defined formats or click Custom Format... to set up your own formatting but since we want new format, we choose custom format.
6th step: In the Format Cells window, switch between the Font, Border and Fill tabs to choose the font style, border style and background color, respectively. On the Font and Fill tabs, you will immediately see a preview of your custom format.
7th step: after this has been done, click okay at the bottom of the window.
