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

On Wed, 25 Jan 2006 04:30:02 -0800, "Simon Jefford"
wrote:

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

You can use an event-triggered macro in VBA.

If you post more specifications, someone will post a solution.
--ron