You need a macro to do this. BUT... you are trying to store information in
formatting. You will probably save yourself a lot of headaches down the road
if you store information as information, i.e. set up a column for the reason,
and enter it there.

On Tue, 8 Feb 2005 23:51:01 -0800, excel_jan
wrote:

In todays Excel it is only possible to set 3 seperate conditions for
formatting cells. I'd like to have some added. Often I just need to set 4 or
5 conditions to cells.
For example: I made a spreadsheet for registrating absence at work.
There are many reasons why someone is not at work. You can simply give these
reasons a colour, but three is not enough.