{"id":7058,"date":"2021-09-03T12:23:53","date_gmt":"2021-09-03T12:23:53","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=7058"},"modified":"2024-03-28T14:47:25","modified_gmt":"2024-03-28T14:47:25","slug":"use-conditional-formatting-when-cell-contains-yes","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/use-conditional-formatting-when-cell-contains-yes\/","title":{"rendered":"Use Conditional Formatting when Cell Contains Yes"},"content":{"rendered":"\n
When you work with spreadsheets, you will quickly figure out how useful is conditional formatting in Excel. We can use it for basically every set of data and highlight only the data that are falling under a certain category.<\/p>\n\n\n\n
In the example below, we will show how to use conditional formatting when we have a certain text in our data set.<\/p>\n\n\n\n
For the example, we will use the list of loans that were applied for, banking officers, and simple yes\/no to show whether the loan was approved or not.<\/p>\n\n\n\n