If you do not want it to be dynamic it would be a fairly simple matter to
write a macro to step through the input table and colour the appropriate
cells.

If you do want it to be dynamic you will need to use the SheetChange event to
redo all the colours in the row  in which the change occurs - sightly more
complex to program and might slow the spreadsheet down noticeably (because it
will be fired by every change in the worksheet).

What parts of this can you do and what parts do you need help with?