Conditional Formatting
I'd use a simpler way to just return the selection made as a value
Assume your array of 8 contiguous horiz cells is in A1:H1
where there will only be a single TRUE at any time
In say, A2:
=IF(ISNA(MATCH(TRUE,A1:H1,0)),"",MATCH(TRUE,A1:H1, 0))
will return a relative number denoting which cell within A1:H1 contains the
TRUE, eg: 2 = B1, 5 = E1, and so on. Any worth? hit the YES below
--
Max
Singapore
---
"John Calder" wrote:
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
|