Getting started with VBA

I need to use excel to layout a show floor for a conference and expo I'm working on. I would like to select a rectangle of cells, hit a key-stroke, and have the selected cells formatted, some formula...