How To Colour a cell in a table using command button

If a table is worked accessed and a cell is modified, (in sheet1 which contains 2text boxes and a command button) when the command button is clicked, the cell which was changed turns red. and in sheet 2, the text of textbox1 and textbox2 are entered in a and b and the time is entered in c and the changed cell address of the table(which is in sheet1) is entered in D