Hi
I have a large grid with rows of 1's or 0's. Some of the 1's are single (ie surrounded by 0's -010) some are in groups of 2 (ie 2 1's beside each other - 0110) some are in groups of 3 etc 01110. up to groups of 8.
I wan to use conditional formatting so that the singles are blue, the doubles are red, the triples are green etc.
I thought it would be straightforward but it doesn't seem to be. I can manage the first 1 in each group but when you fill across problems occur. I tried use ifs, ands and or but to no avail.
any ideas
thanks
I have a large grid with rows of 1's or 0's. Some of the 1's are single (ie surrounded by 0's -010) some are in groups of 2 (ie 2 1's beside each other - 0110) some are in groups of 3 etc 01110. up to groups of 8.
I wan to use conditional formatting so that the singles are blue, the doubles are red, the triples are green etc.
I thought it would be straightforward but it doesn't seem to be. I can manage the first 1 in each group but when you fill across problems occur. I tried use ifs, ands and or but to no avail.
any ideas
thanks