{"id":33720,"date":"2023-12-26T19:42:01","date_gmt":"2023-12-26T18:42:01","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33720"},"modified":"2024-03-22T15:48:54","modified_gmt":"2024-03-22T14:48:54","slug":"conditional-formatting-based-on-another-cell","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditional-formatting-based-on-another-cell\/","title":{"rendered":"How to Use Conditional Formatting Based on Another Cell"},"content":{"rendered":"

\"Conditional<\/a><\/p>\n

One of the most common questions in Microsoft Excel<\/a> is how do you use conditional formatting<\/a> based on another cell\u2019s value?<\/p>\n

Say you want a cell to be highlighted once its\u2019 values hit a certain threshold. If you can format the appearance of cells, your data will be easier to understand. You will also be able to focus on the formatted cells leading to streamlined decision-making. In this article, we will explore the steps on how to use conditional formatting based on another cell.<\/p>\n

Our final product will look like this:<\/p>\n

\"Conditional<\/a><\/p>\n

In this example, we want to highlight the name of the students in column A<\/strong> who have a mark above 80<\/strong> on column C<\/strong>, indicating their passing status.<\/p>\n

Let’s go through these steps thoroughly!<\/p>\n

Download the Excel Workbook below to follow along How to Use Conditional Formatting Based on Another Cell! \u2013<\/h4>\n

download excel\u00a0<\/strong>workbook<\/strong>\u00a0<\/span>ConditionalFormattingBasedonAnotherCell.xlsx<\/span><\/a><\/p>\n

\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n