cell formatting

S

Simon Jefford

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
 
R

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
Click to expand...

You can use an event-triggered macro in VBA.

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