Highlight functionality for indication of empty/missing fields 1

[TBL3]

Hi,

I am working on an application form.
I have many fields that needs to be inputted.
Also, there are mandatory fields that needs to be inputted in order to obtain the final value.

However, my concern is that I wish to code a macro that recognizes all the mandatory fields, and once the mandatory fields are not inputted, the description of the missing field becomes highlighted or change color (indication showing that the field must be filled).

Well, I am lost on how to approach this issue.
Any input or suggestions will be great.Thanks,

 

[TBL3]

I think I lost you.

 

[TBL3]

Anyways, regards to the code I have wrote, does that look okay? or did I miss something?

 

[TBL3]

Regarding to your comment, that is not what I wish to occur.
I do not want the description of the fields to be all in RED initially. I only want the indication once they have completed the last field and realized that they have missed a mandatory field.

Does this make more sense?

 

[SkipVought]

You cannot name your FUNCTION and your RANGE the same thing!!!

ALSO, I would not insert a formula. I would insert the VALUE...

Private Sub Worksheet_Change(ByVal Target As Range)
  if [b]FINAL_score[/b]() = 0 then
    'call your summing procedure
    [[b]FINAL_score_RANGE[/b]].value = application.SUM("T16:T54")      
  end if
End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TBL3]

Thanks skip.

Cheers,
tbl3