Hi all,
I have an excel sheet for recording the results from measurements made on round material.
What I want is to have the conditional formatting so that if they have more than the allowed difference in a column they are highlighted red.
Example:
Allowed difference is 0.06 so the cells with a larger difference would be highlighted red.
<tbody>
</tbody>
I have an excel sheet for recording the results from measurements made on round material.
What I want is to have the conditional formatting so that if they have more than the allowed difference in a column they are highlighted red.
Example:
Allowed difference is 0.06 so the cells with a larger difference would be highlighted red.
580.09 < |
580.06 |
580.02 < |
580.04 |
<tbody>
</tbody>