Hi
I hope someone can help!
I have been asked to create a label merge for some attendance data. The table is very simple and is a single row with four columns (Name, Previous week att. Current week att, difference). The data is imported from a excel spreadsheet.
What i needs is for column 2 and 3 to have scaled colour based on the following;
>96 Green
between 90 and 96 amber
<90 Red
Column 4
=0 amber
>0 green
<0 Red
The label merge needs to apply the above criteria to each of 36 tables created in the label merger.
I hope someone can help as i'm stuck! I am hoping to find a Marco solution
Thanks
Ed