I was wondering if it was possible to align a cell based on the value within another cell.

For Example:

IF Cell A1=>1 AND <= 2 then align Cell B1 left

IF Cell A1=>3 AND <= 4 then align Cell B1 centre

IF Cell A1=>5 AND <= 6 then align Cell B1 Right

I would also want this macro to activate on any change in Cell A1.

Thanks for any help you can provide.

Kind Regards
E