Creating Drop Down List

I am trying to write produce a simple spredsheet for writing school reports. In column G of my spreadsheet the main comment is entered and this can be a maximum of 400 characters. Is there any way of limiting the amount that can be put into a cell or if not is there a simple macro I could use to make the cell go red if the length is over 400?

Jack