{"id":1224,"date":"2022-11-30T20:22:53","date_gmt":"2022-11-30T20:22:53","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1224"},"modified":"2024-02-27T16:38:32","modified_gmt":"2024-02-27T16:38:32","slug":"how-to-apply-conditional-formatting-based-on-another-value-or-a-cell-value-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-apply-conditional-formatting-based-on-another-value-or-a-cell-value-in-excel\/","title":{"rendered":"How to Apply Conditional Formatting Based on Another Value or a Cell Value in Excel?"},"content":{"rendered":"

Conditional Formatting Based on Cell Value in Excel transforms your data visualization, allowing for immediate identification of trends, issues, and opportunities within your datasets. By implementing this dynamic tool, you can enhance data analysis, improve readability, and make informed decisions faster. Whether it’s highlighting outliers, tracking progress, or visualizing data distributions, conditional formatting offers a powerful, intuitive way to present and interpret data. Embrace this feature to elevate your Excel skills and bring clarity and efficiency to your reports and analysis.<\/p>\n

First, we see how to Apply Conditional Formatting Based on Another Value:<\/p>\n

Step 1: <\/strong>From Data set \u2013 Select the cell B2<\/p>\n

\"Conditional<\/p>\n

Step 2: <\/strong>Navigate to Home. In the Style area of the ribbon, select the Conditional Formatting.<\/p>\n

Step 3: <\/strong>Tap on Conditional Formatting, select \u2018New Rule\u2019.<\/p>\n

Highlight values more than 35,000<\/p>\n

\"Conditional<\/p>\n

Step 4: <\/strong>Select the “Use a formula to determine which cells to format” option in the New Formatting Rule dialog box.<\/p>\n

Step 5: <\/strong>Highlight values more than 35,000. So, Enter the following formula in the field: =$B2>35000.<\/p>\n

\"Conditional<\/p>\n

Step 6: <\/strong>Select the Format option (to define how you want the names highlighted).<\/p>\n

\"Conditional<\/p>\n

Step 7: <\/strong>Choose the formatting. Then Click OK.<\/p>\n

\"Conditional<\/p>\n

Result Outlined Below. Apply the \u2018Format Painter\u2019 from cell B2 to B13.<\/p>\n

\"Conditional<\/p>\n

Now we see how apply Conditional Formatting Based on Another Cell Value<\/p>\n

We highlight month value higher than 35,000, i.e., value in cell E2<\/p>\n

Step 1:<\/strong> Select the cell to which you like to apply conditional formatting. Here select B2.<\/p>\n

\"Conditional<\/p>\n

Step 2: <\/strong>Navigate to Home. In the Style area of the ribbon, select the Conditional Formatting.<\/p>\n

\"Conditional<\/p>\n

Step 3: <\/strong>Tap on Conditional Formatting, select \u2018New Rule\u2019.<\/p>\n

Step 4: <\/strong>Highlight values greater than cell value of E2 i.e., 35,000. So, Enter the following formula in the field: =$B2>$E$2.<\/p>\n

\"Conditional<\/p>\n

Step 6: <\/strong>Select the Format option (to define how you want the names highlighted).<\/p>\n

\"Conditional<\/p>\n

Step 7: <\/strong>Choose the formatting. Then Click OK.<\/p>\n

\"Conditional<\/p>\n

\"Conditional<\/p>\n

Result Outlined Below. Brush the Format Painter from Cell B2 to B13.<\/p>\n

\"Conditional<\/p>\n

Conditional Formatting Based on Cell Value in Excel<\/p>\n

Application of Conditional Formatting Based on Cell Value in Excel<\/strong><\/h2>\n
\n
\n
\n
\n
\n
\n
\n
\n