"Jared" wrote in message:

Try something like:

Activecell.Interior.Color=RGB(Red_no,Green_no,Blue _no)


With this Excel will match the defined colour to the nearest colour that
exists in the palette and apply its associated colorindex as the cell
format. Eventual formatted colour may or may not be was believed to have
been defined. Unless trying to apply one of the standard or "pure" colours
the odds are 56 / 16777216 against !

Regards,
Peter