A client wants to color code the customer list based on YTD sales - one color for <10K YTD sales, a second color for 10K to 20K and a third color for >20K. They want the color to change "automatically" when the next level is reached.

Is this doable in Adagio?

They also don't want the color to immediately reset upon year-end but let's deal with that as a secondary issue.

They also want the system to note the date the level (color) changed, but that's yet another issue.

Thanks

Steve