%20(11).png){kind=small}
As the name suggests, conditional formatting is formatting cells concerning certain conditions. The condition, when fulfilled, applies a different format, like a changed colour or font, to make the cells identifiable on the condition being met. The conditions could be the existence of duplicates, specific numbers or texts, IF rules, a pattern, or anything. Formatting can be done by changing the cell colour, border, or font.
We all require conditional formatting while using Excel, so here are five tips on conditional formatting in Excel that will make your work easy.
Management of the existing rules of conditional formatting
Managing existing conditional formatting involves applying a new rule to the pre-set rules, new formats, and so on. To manage the conditional formatting applied in a cell, sheet, or workbook, all you need to do is go to the Home ribbon > Conditional formatting > Manage rule. Select the option for which you want to format the rule. It can be either the current selection or the sheet. You will see all the rules applied to the selected option and make changes as required. Do remember to click the APPLY button after managing the rules. Otherwise, no changes will apply.
Using pre-defined conditional formatting rules
Excel has quite a good range of pre-defined conditional formatting rules. It includes number rules, text rules, date rules, duplicates, icon sets, colour shades, and many more. All these can be used for conditional formatting by making the adjustments per your requirements. To see the pre-defined formatting that can be applied, go to Home ribbon > Conditional formatting, and you can choose what fits your need the most.
Applying custom formatting with pre-defined rules
Pre-defined formats are rapid to apply conditional formatting. Once you choose the formatting you want, you will get the dialogue box to input the values defining the range or criteria for using conditional formatting. If you want to customize the formatting, choose the custom format option to make changes.
Identifying the cells to which conditional formatting has been applied in a sheet
To find the cells in a sheet to which conditional formatting applies, go to Home > Find and Select > Go to Special > Conditional Formats. This way, the cell will be highlighted to indicate that the conditional formatting has been applied. You can also use the shortcut to Go To (the F5 key) and select Conditional Formats.
Deleting Conditional Formatting rules
There are various methods to delete conditional formatting. Firstly, go to Home ribbon> Conditional formatting> Clear rules from the entire sheet or selected cells. Secondly, you can go to Manage Rules. Select the rule and delete it.
It is essential for you to understand the data and the formats that will fit your data the best. Try using the five conditional formatting tips in Excel and let us know which helped you the most in the comment section.
Comments