Forum Discussion
Colormatch function in excel (using VBA code)
I am preparing a scoreboard for different projects. 10 KPIs of different weightage to measure each project performance. Each KPI will have either 3 responses (good, bad, ugly). User will update the r...
Note that Interior.Color returns the color that has been MANUALLY applied. It ignores any Conditional formatting applied colors. To cater for conditional formatting colors, use Range.DisplayFormat.Interior.Color