{"id":4768,"date":"2019-11-11T08:58:56","date_gmt":"2019-11-11T08:58:56","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4768"},"modified":"2024-03-30T11:08:50","modified_gmt":"2024-03-30T11:08:50","slug":"conditional-formatting-based-on-cell-color","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/conditional-formatting-based-on-cell-color\/","title":{"rendered":"Conditional Formatting Based on Cell Color"},"content":{"rendered":"\n
If you want to use conditional formatting where a criterion\nis a cell color, you can’t just use standard conditional formatting. You have\nto create a VBA function that will recognize color and apply adequate\nformatting.<\/p>\n\n\n\n
In this tutorial, we are going to create a formula that will\nname a color based on the cell<\/a> background.<\/p>\n\n\n\n Let’s take standard colors from the Excel palette. You can find them in Home >> Font >> Fill Color >> Standard Colors<\/strong>.<\/p>\n\n\n\n