Hi , is it possible to colourcode rows in a subform datasheet based upon them being higher / lower than the previous row ? ...
Subform datasheet has, e.g.
Row1 £12.50
Row2 £10.25
Row3 £15.50
So, i would want Row2 to be Red because it is less than Row1 value, but then Row3 to be Green because it is more than Row2 valuem, and so on - hope that makes sense. Thanks.
Subform datasheet has, e.g.
Row1 £12.50
Row2 £10.25
Row3 £15.50
So, i would want Row2 to be Red because it is less than Row1 value, but then Row3 to be Green because it is more than Row2 valuem, and so on - hope that makes sense. Thanks.
