log staff's flexi times

I am writing a flexi time spreadsheet to log staff's flexi times.

The attached code relates to a worksheet where the user selects what type of day they are entering flexi times for (Normal, Annual Leave, Flexi Leave, Sick Leave etc.).

Depending on what is selected in the drop-down list (E Column) cells will change color and/or value and/or formula.

The attached code works fine for Cell E14. However, I need to repeat the code for cells E15:E20, transposing the cell references in the process.

I've played around with 'Loop' and 'For Each Cell in Range' commands but can't seem to figure this one out!

Any help is appreciated guys!!!