Spreadsheet: 738804d1625241531-how-to-get-percentage-of-red-shaded-cells-from-formatting-sample-question
Sheet: Sheet1

 |  |  |  |  |  |  |  | DIMENSION | AXIS | NOMINAL | +TOL | -TOL | 4/10/2021 | 4/11/2021 | 4/14/2021 | 4/14/2021 | 4/14/2021 | 4/15/2021 | 4/16/2021 | 4/16/2021 | 4/19/2021 | 4/20/2021 | 4/21/2021 | 4/21/2021 | 4/22/2021 | 4/22/2021 | 4/23/2021 | 4/26/2021 | 4/27/2021 | 4/27/2021 | 4/28/2021 | 4/30/2021 | 4/30/2021 | 4/30/2021 | 5/3/2021 | 5/3/2021 | 5/3/2021 | 5/4/2021 | 5/4/2021 | 5/4/2021 | 5/5/2021 | 5/6/2021 | 5/13/2021 | 5/19/2021 | 5/20/2021 | 5/27/2021 | 6/1/2021 | 6/3/2021 | 6/4/2021 | 6/7/2021 | 6/9/2021 | 6/11/2021 | 6/22/2021 | 6/25/2021
 |  |  |  |  |  |  |  | [NAME] dimensions
 |  |  |  |  |  |  |  | 5-1LH | S | 0 | 0.5 | 0.5 | -0.718 | -0.992 | -0.695 | -0.698 | -0.58 | -0.844 | -0.332 | -0.749 | -0.982 | 0.094 | 0.141 | 0.13 | 0.265 | 0.126 | 0.576 | 0.294 | 0.253 | 0.351 | 0.453 | -0.659 | -0.171 | -0.193 | -0.677 | -0.105 | -0.281 | -0.461 | -0.388 | 1.602 | -0.601 | -0.636 | -0.84 | -0.521 | -0.888 | -0.114 | -0.569 | -0.346 | -0.094 | -0.816 | -1.067 | -0.847 | -0.944 | -0.31
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-2 | S | 0 | 0.5 | 0.5 | -0.083 | -0.233 | -0.078 | -0.073 | 0.041 | -0.302 | 0.049 | -0.299 | -0.244 | 0.166 | -0.191 | 0.063 | 0.4 | 0.096 | 0.432 | 0.205 | 0.132 | 0.308 | 0.372 | -0.3 | -0.06 | 0.09 | -0.201 | 0.122 | -0.241 | -0.055 | -0.276 | 1.245 | -0.118 | -0.453 | -0.29 | -0.269 | -0.457 | 0.156 | -0.228 | -0.059 | 0.285 | -0.438 | -0.365 | -0.62 | -0.531 | -0.197
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-3 | S | 0 | 0.5 | 0.5 | -0.154 | -0.357 | -0.144 | -0.247 | -0.303 | -0.289 | 0.105 | -0.352 | -0.346 | 0.221 | 0.039 | -0.06 | 0.327 | -0.089 | 0.128 | -0.122 | -0.048 | 0.09 | 0.165 | -0.521 | -0.305 | -0.185 | -0.396 | -0.266 | -0.458 | -0.315 | -0.469 | 0.693 | -0.431 | -0.609 | -0.637 | -0.416 | -0.544 | 0.103 | -0.162 | -0.021 | -0.075 | -0.238 | -0.75 | -0.482 | -0.485 | -0.444
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-4 | S | 0 | 0.5 | 0.5 | -0.448 | -0.558 | -0.417 | -0.477 | -0.451 | -0.488 | -0.26 | -0.553 | -0.603 | 1.118 | -0.808 | 0.824 | 1.145 | 0.959 | 1.05 | 0.967 | 0.926 | 1.015 | 1.07 | -0.648 | -0.44 | -0.389 | -0.55 | -0.454 | -0.531 | -0.481 | -0.609 | 0.194 | -0.521 | -0.68 | -0.816 | -0.594 | -0.641 | -0.115 | -0.352 | -0.181 | -0.218 | -0.361 | -0.837 | -0.59 | -0.602 | -0.527
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-5 | S | 0 | 0.5 | 0.5 | -0.856 | -0.983 | -0.808 | -0.953 | -0.958 | -0.911 | -0.724 | -1.051 | -0.99 | 1.839 | -0.569 | 1.584 | 1.773 | 1.578 | 1.701 | 1.508 | 1.553 | 1.626 | 1.675 | -1.18 | -1.021 | -0.987 | -1.036 | -0.978 | -1.055 | -1.041 | -1.126 | -0.474 | -1.078 | -1.098 | -1.194 | -1.017 | -1.05 | -0.492 | -0.657 | -0.566 | -0.726 | -0.697 | -1.117 | -0.925 | -0.884 | -1.003
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-6 | S | 0 | 0.5 | 0.5 | -1.645 | -1.111 | -0.327 | -1.148 | -0.363 | -0.335 | -0.539 | -0.352 | -0.546 | -0.026 | -0.925 | -0.413 | -0.571 | -0.344 | -0.191 | -0.624 | -0.372 | -0.328 | -0.286 | -1.213 | -0.376 | -0.781 | -2.915 | -0.183 | -0.255 | -0.38 | -0.644 | -0.171 | -0.358 | -0.691 | -0.369 | -0.081 | -0.212 | -1.869 | -0.255 | -0.032 | -0.016 | -0.116 | -0.174 | -4.3 | -0.039 | -3.576
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-7 | S | 0 | 0.5 | 0.5 | -0.832 | -0.147 | -0.352 | -0.457 | -0.29 | -0.316 | -0.358 | -0.303 | -0.48 | -0.029 | -0.839 | -0.368 | -0.214 | -0.283 | -0.225 | -0.469 | -0.422 | -0.412 | -0.368 | -0.613 | -0.314 | -0.522 | -0.459 | -0.109 | -0.213 | -0.299 | 0.299 | -0.056 | -0.228 | -0.586 | -0.25 | 0.055 | -0.204 | -0.433 | -0.223 | 0.073 | 0.184 | 0.018 | -0.129 | -1.997 | -0.057 | -2.225
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-8 | S | 0 | 0.5 | 0.5 | -0.36 | -1.101 | -0.353 | -0.099 | -0.08 | -0.241 | -0.126 | -0.254 | -0.399 | -0.088 | -0.87 | -0.508 | -0.233 | -0.353 | -0.283 | -0.55 | -0.487 | -0.676 | -0.634 | -0.711 | -0.345 | -0.482 | -0.297 | -0.155 | -0.281 | -0.654 | 1.063 | -0.029 | -0.221 | -0.631 | -0.249 | -0.011 | -0.319 | -0.193 | -0.348 | -0.092 | 0.078 | -0.203 | -0.323 | -0.05 | -0.119 | -0.204
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-9 | S | 0 | 0.5 | 0.5 | -0.599 | -0.513 | -0.563 | -0.401 | -0.354 | -0.544 | -0.471 | -0.542 | -0.665 | -0.441 | -1.12 | -0.91 | -0.594 | -0.698 | -0.676 | -0.917 | -0.837 | -1.12 | -1.08 | -1.074 | -0.727 | -0.811 | -0.563 | -0.539 | -0.635 | -0.819 | 0.035 | -0.284 | -0.504 | -0.8 | -0.492 | -0.26 | -0.643 | -0.393 | -0.679 | -0.363 | -0.175 | -0.467 | -0.689 | -0.321 | 0.103 | -0.362
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-10 | S | 0 | 0.5 | 0.5 | -0.485 | -0.247 | -0.542 | -0.299 | -0.201 | -0.449 | -0.246 | -0.344 | -0.578 | -0.293 | -0.948 | -0.962 | -0.478 | -0.514 | -0.59 | -0.948 | -0.823 | -0.867 | -0.828 | -0.976 | -0.57 | -0.652 | -0.317 | -0.209 | -0.484 | -0.529 | -0.462 | -0.071 | -0.321 | -0.507 | -0.394 | -0.151 | -0.647 | -0.152 | -0.676 | -0.272 | -0.074 | -0.423 | -0.307 | -0.14 | -0.498 | -0.142
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-11 | S | 0 | 0.5 | 0.5 | -0.341 | 0.046 | -0.452 | -0.11 | 0 | -0.224 | -0.017 | -0.176 | -0.44 | -0.131 | -0.766 | -0.922 | -0.328 | -0.378 | -0.45 | -1.058 | -0.804 | -0.806 | -0.767 | -0.854 | -0.543 | -0.691 | -0.437 | 0.034 | -0.32 | -0.333 | -0.545 | 0.15 | -0.136 | -0.246 | -0.212 | -0.411 | -0.528 | 0.03 | -0.579 | -1.294 | -0.263 | -1.419 | -0.574 | 0.107 | -0.375 | -0.286
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-12 | S | 0 | 0.5 | 0.5 | -0.306 | 0.062 | -0.207 | -0.13 | -0.121 | -0.266 | -0.295 | -0.251 | -0.316 | -0.179 | -0.556 | -0.321 | -0.239 | -0.374 | -0.336 | -0.341 | -0.425 | -0.388 | -0.376 | -0.326 | -0.363 | -0.191 | -0.176 | -0.123 | -0.329 | -0.333 | -0.85 | -0.252 | -0.108 | -0.36 | -0.467 | -0.466 | -0.52 | -0.107 | -0.271 | -0.2 | -0.061 | -0.319 | -0.366 | -0.535 | -0.259 | -0.514
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-13 | S | 0 | 0.5 | 0.5 | 0.326 | 0.431 | 0.645 | 1.082 | 1.043 | 0.899 | 1.09 | 0.743 | 0.777 | 0.486 | 0.002 | -0.23 | 0.221 | 0.205 | 0.232 | -0.272 | -0.288 | 0.106 | 0.122 | -0.338 | 0.221 | -0.01 | 0.405 | 0.544 | 0.23 | 0.274 | 0.369 | 0.615 | 0.369 | 0.425 | 0.412 | 0.645 | 0.189 | 0.691 | 0.06 | 0.603 | 0.833 | 0.677 | 0.676 | 0.593 | 0.004 | 0.79
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-14 | S | 0 | 0.5 | 0.5 | -0.675 | -0.715 | -0.72 | -0.678 | -0.759 | -0.732 | -0.693 | -0.618 | -0.713 | -0.744 | -0.472 | -0.725 | -0.51 | -0.571 | -0.574 | -0.666 | -0.418 | -0.622 | -0.633 | -0.645 | -0.551 | -0.465 | -0.54 | -0.568 | -0.6 | -0.515 | -0.559 | -0.578 | -0.569 | -0.589 | -0.468 | -0.469 | -0.5 | -0.646 | -0.698 | -0.888 | -0.727 | -0.737 | -0.533 | -0.466 | -0.785 | -0.404
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | 5-15 | S | 0 | 0.5 | 0.5 | -0.561 | -1.643 | -0.865 | -0.469 | -0.298 | -0.307 | -0.196 | -0.43 | -0.518 | -0.141 | -0.619 | -0.835 | -0.323 | -0.477 | -0.685 | -0.858 | -0.74 | -0.521 | -0.496 | -1.014 | -0.421 | -0.555 | -0.253 | 0.032 | -0.461 | -0.371 | -0.526 | -0.158 | -0.308 | -0.212 | -0.477 | 0.101 | -0.861 | 0.185 | -0.432 | -0.049 | -0.509 | -0.277 | 0.03 | -1.21 | -0.91 | -0.028
 |  |  |  |  |  |  |  | Line skip
 |  |  |  |  |  |  |  | Percentage