The information gathered is for Communitic International to ensure the sending of the newsletter.
The information will be used subject to terms and conditions, for advertising purposes.
You reserve the right to access and change your personal data, aswell as the right to request its deletion within the limits permitted by law.
You can also review your targeting options. For more information, click this privacy policy
.
Still working on this problem though.
If you have 50 different shaded of gray, all with different values, you could perform this. Just start from the least significant, in this case .00-.99, then 1 to 1.99, then 2 though 2.99. Sometimes significance isnt' really a numeric value, but a number of different cases, so for this we would look to such formulas as:
=if(and(a1=yes,b1=yes)) = GREEN CELL (as far as we are concerned, every cell should be a GREEN CELL)
Then our next formula checks to disqualify the green cells, as in:
=if(and(a1=yes,b1=no)) = RED CELL
Then we would check for the next qualifying (in this case, disqualifying), but this time we will turn it yello, because it can still be green, and it it isn't RED. A YELLOW CELL maybe found with:
=if(and(a1=no,b1=yes)) = YELLOW CELL
Is this where you are having problems? Let us know so you can expand on the scope of the project.
what you have written makes logical sense and taking this I am going to try and assemble it all into a coherent (and working) set of conditional formatting.
I have a week away from it all, so will try on my return. Thanks again,
Have fun!
Thanks again