Conditional formatting can make the data in a spreadsheet easier to read. One way it can do this is by applying a specific color or style to highlight cells based on their value. But how does it work? In this post, we look at how to highlight cells via the conditional formatting in Microsoft Excel.\r\nHow to Highlight Cells with Conditional Formatting\r\n\r\nIn Microsoft Excel, you can apply styles to cells depending on their content by setting a conditional formatting rule (i.e., a set of conditions in which the formatting will apply). Excel comes with a few pre-set options for this, all of which are available via the Conditional Formatting option on the Home tab.\r\n\r\nHowever, we're focusing on highlighting cells in this post. To do this:\r\n\r\n\tSelect the cells you wish to format.\r\n\tGo to Home > Styles > Conditional Formatting on the ribbon.\r\n\tIn the drop-down menu, hover the cursor over Highlight Cells Rules.\r\n\tPick an option from the menu.\r\n\r\nThis opens a pop-up where you can set a value (i.e., the value or text that triggers the formatting in the selected cell[s]) and a style (i.e., the formatting to apply).\r\n\r\nWhen you're done, click OK to apply the formatting to your chosen cells. In the example below, we've highlighted cells with a value greater than \u00a3500.\r\n\r\nThere are a few options available here, though, so let's look at them next.\r\nPre-Set Rules Available in Excel\r\nIf you follow the instructions above, you'll see a list of pre-set rules you can use to highlight cells using conditional formatting:\r\n\r\n\tGreater Than \u2013 Applies the chosen formatting when a cell exceeds the stated value (e.g., in our example above, we've set it to apply red shading and text in any cell with a value over 500).\r\n\tLess Than \u2013 As above but for cells beneath the stated value.\r\n\tBetween \u2013 Applies formatting when a cell falls between two values.\r\n\tEqual To \u2013 Applies formatting for cells containing an exact value.\r\n\tText that Contains \u2013 Formats cells that contain a set word or phrase.\r\n\tA Date Occurring \u2013 Highlights cells that fall within the set date criteria (e.g., this week, next week, this month, next month).\r\n\tDuplicate Values \u2013 Highlights cells that contain the same value or text as another cell with the same conditional formatting.\r\n\r\nYou can also select More Rules from the menu to create a custom formatting a rule. However, the pre-set options should cover most of your basic requirements for highlighting cells based on their values.\r\nRemoving Conditional Formatting\r\nFinally, there will be times you wish to remove some or all the conditional formatting rules from your data. This is easy to do:\r\n\r\n\tSelect the cells from which you want to remove formatting.\r\n\tOnce again, go to Home > Styles > Conditional Formatting.\r\n\tIn the menu, select Clear Rules and click Clear Rules from Selected Cells.\r\n\r\n\r\nThis will remove the formatting as selected. In addition, selecting Manage Rules in the menu will open a list of all the conditional formatting in a spreadsheet. You can then delete or edit rules as required.\r\nExpert Spreadsheet Proofreading\r\nAs well as using conditional formatting effectively, you\u2019ll want the text in your spreadsheets to be free from errors. And the best way to do this is to use our spreadsheet proofreading services. We have experts ready to help!