I have a spreadsheet that I continously have to format. It is a data dump
from another application. It could be any number of rows and any number of
columns. I need a macro that will look at column A and format B based on
the number in Column A. So if Column A is 2 then indent Col B 5 spaces, if
Col A is 3 then indent Col B 10 spaces, if Col A is 4 then indent Col B 15
spaces. Also if Col B is Bold then shade row Gray.

Thanks in advance for your help.
clv