Macro to change table cell background colors?

[Steve]

So, we have a page with a table on it, that we will modify with test results, so we will modify the background to green, for passing, yellow for in progress, etc.

Currently everyone has to select the table cell, and then change the color manually. I would like to find a way to do this with a macro.  I could see a row of buttons next to the cell that our users could push based on where we are in the testing process, and have the background and cell wording change appropriately.  

What's the best way to proceed?  I don't see a way to name a table cell that a macro can them modify........

It may help to note that different tests may have multiple table rows, and have different options for the same column, for each row.

Hopefully this makes sense....

[Bill Bailey]

How about user macro based on the status macro? Then you they can just open the macro, and select from a set of statuses and the color would predefined.

The user macro acts as a wrapper around the status macro to make configuring it quicker and restricts it to set of values.