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