[code][code]I am new to these forums so I hope someone can help me a problem that has vexed me.
I am filtering on "6's" using colors. I made r2c7 Blue and r2c9 green. Then I colored r5c7 green and r5c8 Blue.
Column 7 now contained both a blue and green cell so I thought that I could exclude a "6" from r7c7. That didn't work and to my surprise, it turned the "6" in c7 was in r7c7. What mistake an I making????? Thanks.
[code]*--------------------------------------------------------------------*
| 3 25 1 | 9 25 6 | 8 4 7 |
| 2489 289 7 | 1348 1238 13 | 126 5 1369 |
| 2489 6 24589 | 13478 12358 57 | 12 239 139 |
|----------------------+----------------------+----------------------|
| 6 1237 234 | 5 9 8 | 17 3 134 |
| 5 89 489 | 13 7 13 | 46 689 2 |
| 1789 13789 389 | 6 4 2 | 157 389 1359 |
|----------------------+----------------------+----------------------|
| 178 3578 358 | 1378 13568 9 | 2456 26 456 |
| 278 4 2358 | 378 3568 57 | 9 1 56 |
| 19 159 6 | 2 15 4 | 3 7 8 |
*--------------------------------------------------------------------*[/code]