Any suggestions on this?
Attached is a solution in 9.3, but it appears you created the workbook in a earlier release and may not be able to open it.
In that case, here's the calc that you need to drop onto the color shelf:
if index() >=1 and index() <=3
elseif index() >=4 and index() <=5
then "Light Red"
Also, I encourage you to upgrade to the latest release as soon as possible and enjoy all the great new features and performance improvements.
Coloring Help (1).twbx 547.4 KB
thank you very much.
And we just upgraded to 9.3!