How to convert a number result into a colour on an excel spreadsheet

Hi,   I want to use colours to represent numbers on an excel spreadsheet through a formula or macro and keen to get help and tips from here.   Is this feasible, if so how do I go about it?   Th...