Yes you will need to run the macro again in order for it to colour based on the new data.

ALT+F8 will display the macro dialog, where you can select the macro and run it.

You can assign the macro to a shape or button to make it easier to refresh.