Showing Variances

[TwinHype]

Hi All,

I have 2 sets of fields, 1 for this week and 1 for last week.
I would like to change the background colour of this weeks fields to show either an increase (green) or a decrease (red) from last weeks figures.

Can anyone help me?

Thanks

Twin

 

[meanster99]

use conditional formatting...

search the forum for more info if needed.

Good luck

 

[TwinHype]

Hi,

I can't find conditional formatting in Access. Can you direct me, I have tried searching but haven't come up with anything I recognise.

Let me know

Thanks

Twin