Changing Row Colours in a Report (1 Viewer)

Hello all,

Is there a code where I can specify a customer colour in a table and then use this to colour a row background in a report?

Lets say I add 3 customers, I want to be able to specify the colour for each customer in a table, but this may be able to change if required.

I am sure I have read something like this before, but cannot find it.

~Matt

You could use a reference table with different colours assigned for each customer. I do something similar with different types of event in calendar forms/reports

Try looking at these two related pages on my website


Alternatively, add a reference field to your table & use a different value for each customer. Then use conditional formatting based on the value of that field

You are thinking pretty small if you want to assign a color to each customer. How many customers do you plan to have? There are very few colors that work well as backgrounds and you will run out of them in short order.