In Excel moving a column involves a four step cumbersome process which, if it needs to be repeated many times
could be quite annoying and time consuming.
Would you like to know how to create a macro to move columns and rows in Excel?
Below is the start up code. With our Excel VBA course you could learn this and more
In the example below the indicator is:
RED – If a task hasn’t been completed and it’s finish date is in the past (i.e it’s impossible to finish it on time)
AMBER – If work is behind schedule (% complete is less than % elapsed duration) but the finish date is in the future
GREEN – Work done isn’t behind schedule