In .com, Dave
spake thusly:

Is there anyway you can get more than 3 colours to be displayed
in the cell?

Aside from the add-in UDF another poster mentioned, you can actually
have four colors using conditional: you set up the default color
judiciously, and that counts as four (or one). Also, you can
use custom cell formatting (not conditional formatting) to give
certain numbers certain colors -- similar to how Excel already
offers to display negative numbers red as one optional number
format.

-dman-