cell formatting

[Guest]

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

 

[Ron Rosenfeld]

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