I'm trying to develop an Excel application that records judges' scores for dance competitions.
Judges enter scores against 10 criteria classified in three categories.
If perfect, each category would add up to 20 points and hence the perfect total score will be 60.
In order for a competitor to obtain qualifier for a title, two out of three judges must give at least 10 for all three categories and at least 45 for the total.
I've developed the application so far that the scores entered in userform calculates (upon click of "Calculate" button) and transfers the scores to a worksheet (upon click of "Submit" button).
I would like to have the cells of category subtotal scores with values less than 10 highlighted with light yellow colour and the same with total score cells less than 45.
The following code would do what I want for the less-than-45 part but not for the subtotal-less-than-10 component.
Whenever there is a subtotal less than 10, it highlights the right-most cell in the row with ID number.
I'm not totally versed with the use of array and I'm thinking that's where I'm not doing right but don't know how to correct it.Please Login or Register to view this content.
Could someone please help? I've attached a file that describes what I'm doing.
Thanks heaps.
Maki
Bookmarks