Max

The person I am doing this for is really keen to have colour as the
identifier but if all else fails I will definately look at your option.


Thanks

"John Calder" wrote:

Hi

I run Excel 2K

Conditional Formatting in Excel 2K only allows three conditions to be
applied. I need 8 conditions.

What I have is 8 check boxes that indictate TRUE or FALSE depending on
wheather the check box had been ticked or not.

Check Box 1 linked to cell IN2
Check Box 2 linked to cell IO2
Check Box 3 linked to cell IP2
Check Box 4 linked to cell IQ2
Check Box 5 linked to cell IR2
Check Box 6 linked to cell IS2
Check Box 7 linked to cell IT2
Check Box 8 linked to cell IU2

I would like to nominate a cell (say U2) that changes colour depending on
which of the 8 check boxes is ticked.

Is there a way of doing this?

Thanks