Apply an Automated VBA Solutionįinally we introduce a solution we recommend everyone who is creating excel dashboard using conditional formatting. We can find out in a matter of moments the name and the changed color code with macro recording. We don’t need at all advanced knowledge of VBA. It’s not very hard to create this code, isn’t it? If the text is = “YELLOW” will color the object yellow.Īnd if the C8 cell contains the word “GREEN”, than it will color it green. ![]() ![]() On other cases (for example if the C8 cell doesn’t contain the word “RED”) will do the following. If the value of C8 cell = “RED”, than that will highlight the shape called Shape1 that can be found on the current / active worksheet, than changes its color to red.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |