Comparing two sets of option button groups in Excel using VBA

Question

I have two excel sheets in the same workbook which are used to compare employee required job level with employee evaluated job level. The process starts with the employee manager defining the tasks the employee shall be able to do and the required knowledge level (Level 1 to Level 4) after that an assessment is done to the employee and his actual level in completing the task is determined in the second sheet. If the employee performance is equal to or exceeds the required level then he is considered competent in the task, otherwise he is not considered competent.

Illustration for both sheets filled is below:

I need the background color of the selected option button in the evaluation sheet to be highlighted according to the manual selection of competency level by employee manager with either green or red according to comparison with the same task in the requirement sheet. If the employee evaluation level is equal to or higher than the required level the color of the back ground color shall be green, while if it is less than the required level it shall be red. If no one from the 4 levels is selected in the evaluation sheet for a task, this task buttons is not highlighted.

I created 4 ActiveX controls representing 4 levels for each task in each sheet. I created a group named by task number for each 4 controls in each row as below example:

• In evaluation sheet: TaskE 1.1
• In Requirements sheet: TaskR 1.1

My idea is to trim the text in the selected button caption and in the group names and compare the remaining digits (1 to 4 in buttons or i.e. 1.1 in group names) to determine which level is larger between both sheets and highlight the color based on that.

Thanks.