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...
Please provide us with some sample data, the current formula and the expected outcome(s). Also, for me, your current description of the problem is confusing. Can you please try to rephrase it?
Hi, If you see in the image attached in my question, when user updates as "On time" from dropdown options in the 1st KPI row.. It will automatically displayed with Green color because of conditional formatting. To use the Colormatch function, i just manually filled the same color in F1 cell for reference. If i use the following formulae "If(Colormatch(F1:F4),True,False)" my expected outcome should be "True" but it is coming as "False".
