How to Create a New Conditional Formatting Rule in Excel
You can create a new Conditional Formatting Rule in Excel from scratch. To do so, follow these steps:
Step 1: Select the Cell or Cells you Want to Format
Step 2: Navigate to the Home Tab and Select Conditional Formatting and Click New Rule
Step 3: Select the Rule Type and Click Ok
Now select the rule type, in the New Formatting Rule dialog box
Step 4: Click the Format button, Choose the Color, and Click Ok
Step 5: Preview Result
Conditional Formatting in Excel
Excel Conditional Formatting is a handy feature that helps you visualize data and understand your spreadsheets better. Consider a worksheet that has tens of thousands of rows of data. Simply by looking at the raw data – patterns and trends would be very difficult to spot. By applying formatting rules to cells, anyone can spot patterns easily and changes in your data. With a range of preset formatting options and customization choices, conditional formatting provides flexibility as well as efficiency in analyzing and data presentation.