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.
[TABLE="width: 64"]
<tbody> [TR]
[TD] 580.09 < [/TD]
[/TR]
[TR]
[TD]580.06[/TD]
[/TR]
[TR]
[TD] 580.02 <[/TD]
[/TR]
[TR]
[TD]580.04
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 64"]
<tbody> [TR]
[TD] 580.09 < [/TD]
[/TR]
[TR]
[TD]580.06[/TD]
[/TR]
[TR]
[TD] 580.02 <[/TD]
[/TR]
[TR]
[TD]580.04
[/TD]
[/TR]
</tbody>[/TABLE]