This video demonstrates how to write a VBA macro that will:

Change the background colour of a cell,
Change the font colour
Change the border colour.

You can specify colour in a number of ways in VBA including built in vb colours and built in rgb colours You can also specify RGB colours using your own red, green and blue values.
------------------------