User form problems

Can some one help please?
I found this excel form on the forum and tried to change some of it, for my use but I am stuck at some point. Please click on OPEN FORM button on the sheet then help me.
Here is my list of points that I want be able to when I m using this form ;
I like to have

1-if I leave BANKED section blank I like the whole Row text turn in red so that I know that cheque has not been banked.
2-When I enter date I want excel sheet date format as text format like 15-Apr-2006.
3-Is it possible to have text format in capital letters for all boxes in user form.
4-How do I get rid of grey colour on the excel sheet then it looks normal cells.

Thank you for your time