Excel: Compare values and mark them in color
If you want to compare values in Microsoft Excel and then mark them in color according to a certain criterion, you can do this with the help of the Conditional Formatting function. Learn here how to use the function in Excel and what other options there are for comparing and highlighting values.
How to compare and highlight values in ExcelTo make trends or patterns in your data clear, Excel gives you the ability to compare and visually highlight values using the Conditional Formatting feature.
- Start Excel.
- Mark one or more values you want to compare.
- Switch to the "Start" tab and click on "Conditional Formatting".
- Select "Cell Highlighting Rules" and click on one of the various pre-made rules.
- Now either directly specify the value with which your selection should be compared or specify a cell with a comparison value.
- Click "OK" to apply the rule.
Create your own rulesIn addition to the predefined rules, you also have the option to define your own rules.
- Mark the cell range that you want to format with a custom rule.
- Switch to the "Start" tab.
- Click on "Conditional Formatting" at Styles and select the option "New Rule...".
- Use the input mask to customize the new rule accordingly.
- Finally click on "OK".