{"id":5888,"date":"2021-05-31T12:25:43","date_gmt":"2021-05-31T12:25:43","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=5888"},"modified":"2024-03-26T15:23:50","modified_gmt":"2024-03-26T15:23:50","slug":"format-cells-based-on-the-condition-or-content","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/format-cells-based-on-the-condition-or-content\/","title":{"rendered":"Format Cells in Excel Based on the Condition or Content"},"content":{"rendered":"\n
Format-Cells-in-Excel-Based-on-the-Condition-or-Content<\/a>Download File<\/a><\/div>\n\n\n\n

There are a lot of times when you have a set of data in Excel, and you need to highlight certain figures, numbers, or text based on their values.<\/p>\n\n\n\n

This could be the case when you need to highlight the range of numbers larger or smaller than some certain value, or anything similar.<\/p>\n\n\n\n

Whatever the case may be, the perfect tool to manipulate data in this way is Conditional Formatting<\/strong>.<\/p>\n\n\n\n

Conditional Formatting<\/h2>\n\n\n\n

For this example, we created a table of banking loans, with columns that describe loan amount, the month of approval, and loan duration.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Our table has 40 rows in total, but we presented only a couple of them, just for the preview.<\/p>\n\n\n\n

Now, suppose that somebody says to us that he\/she wants all the loans that were approved in May<\/strong> highlighted in green.<\/p>\n\n\n\n

For this, we can use Conditional Formatting<\/a>.<\/p>\n\n\n\n

Conditional Formatting<\/strong> is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria.<\/p>\n\n\n\n

Conditional Formatting<\/strong> is located in the Home <\/strong>tab, in the subtab Styles<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This Excel function has some pre-defined data formatting sets:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n