I am trying to colour the interior of cells in an excel spreadsheet. I want to set a colour which I am deriving from a routine based on a “NoteNum”. This is just a number from a sequence from 1 to about 1600. The routine takes various actions and then returns an RGB value. This is performing exactly as I expect. It is producing rgb values that are all slightly different so that I can have a large range of colour values.