I would like to format cells based upon the contents of another cell. The
cell determining the format has five variations - which means I cannot use
conditional formatting as this is limited to three variations. When changing
the format, I would like to change both forground and background colour.

Any help would be much appreciated.
Thanks. Simon