If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting
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 |
Thread Tools | |
Display Modes | |
|
|