Macro for Column, Formatting

I'm looking for a macro that will format a column in grey down to the last cell with a value "END" .

Your help would be appreciated

GR2L

1. record a macro
2. format your columns to gray until the value "END"
3. stop macro