Excel has a Condititional Formatting tool that is quite adequate for the needs of users. However, the built-in formats of Excel are not enough to meet your needs, Excel supports users to easily create new rules.
The format rules are available in Conditional Formatting
Conditional Formatting is located in the Home tab. To set the format for a range / column / row of data, select (highlight) the data range. Select the Home tab (1) and click on the Conditional Formatting icon (2) .
Highlight cells Rules - Rules highlight cell colors according to value rules
For example, in the table above, you find the revenue values greater than 4,000,000,000 and highlight that cell color => You select Greater than. In the value comparison section, you type the number 4,000,000,000,000 (1) . In the highlighted color section (2) , you can choose from the available Excel formats or customize by selecting Custom Format .
After selecting all the options, click the OK button. As a result, cells containing values greater than 4,000,000 are highlighted.
Top / Botton Rules - The rules for determining cells by rank
Excel determines the cell's rank in the data range and formats that cell.
For example, the table above, you need to format the color cells smaller than the average value of the data range, select Below Average. The format options window appears, you can choose the available formats of Excel or customize by selecting Custom Format . Then press the OK button .
Data Bar - Format the size of each value
With this format, the size of each cell in the data range will be determined by long or short highlighting.
Color Scale - A rule to organize data in ascending and descending order according to the color density
This rule will arrange the order of each cell in the string and highlight the color according to the format that the user chooses.
Icon Set - Add symbols in the value box
With this type of format, Excel groups data by special symbols such as arrows, traffic lights, etc.
Create a new format rule in Excel
If the types of formatting rules available do not meet the needs of the report, you can set up the new format by:
Step 1: Select (black out) the data area to be changed. On the Home tab (1 ), click on the Conditional Formatting icon (2) and select New Rule (3) .
Step 2: New Formatting Rule window appears.
(1) Select a Rule Type : select the type of data classification you need to perform.
(2) Edit the Rule Description : Optionally set the description for the data classification type you selected above.
With the above settings, Dexterity Software has set the format for the largest number, the color is orange and darker to the smallest. The results are as follows:
Delete and manage formatting rules
To check and manage format rules, go to Conditional Formatting and select Manage Rules. The Manage window will appear, based on this window you can know which cell rules are applying. Here you can add formatting, edit / edit formats and delete formatting.
To delete all Conditional Formatting formats , you cannot edit by Fill (highlight the cell color), but you must delete the installed format by:
Step 1: You only black out the data area but need to delete the format. On the Home tab (1 ), click on the Conditional Formatting icon (2) and select Clear Rules (3) .
In which: Clear rules from selected Cells is to delete the format in the currently selected cell.
Clear rules from entire Sheet is to delete all formatting from the open worksheet.
Above Software Tips showed you how to use Conditional Formatting format tool in Excel. Good luck!.
ncG1vNJzZmismaXArq3KnmWcp51ktbDDjK2mZq2jmnqku82doK2hn6OurXnFqKmmmaSptq%2BzjK2mZpufo7GqwMiopZqkXZu8s7nArauippditq95xLGanqQ%3D