I would like to know how I can create rule to highlight when column A - b > 50, and <-50
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>I tried this, but it did not work
=OR(AND((A2-B2)>50,(A2-B2)<-50))
TIA..
<tbody> </tbody> |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
=OR(AND((A2-B2)>50,(A2-B2)<-50))
TIA..