![]() Enter the comparison parameters (e.g., is greater than 100).Select an existing Rule Set or create a new rule set by clicking New Rule. ![]() Select the Home menu then click Conditional Formatting.Highlight the cells containing the data you want to format.Open the sheet containing the data you want to format.This feature offers some very fast ways to compare and display data in Excel using a set of rules you can use to achieve your conditional formatting objectives. Using conditional formatting in ExcelĬonditional formatting is an under-used yet very powerful Excel feature that you may find useful. If you have longer columns, enable Synchronous Scrolling (from the View Tab in the Windows Group) so that both workbooks scroll alongside each other. The last step, selecting Vertical displays the columns vertically, making it easier for you to read the results of your comparisons. ![]() ![]() The two workbooks will be shown horizontally next to each other by default, which is not ideal for comparing columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |