software

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, quot;Simon Jeffordquot;
gt; wrote:

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

You can use an event-triggered macro in VBA.

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