>> how to translate the long color to a web color class
p_web.ColorToWeb(color) which uses StringTheory.ColorToHex(color,true)
From the StringTheory docs,
! takes in a color in Clarion or Web (#abcdef , #FFF, name) format and returns the color in web format.
so you can pass in a clarion long, #aaa, #aaaaaa, or "colorname" (like 'red','green',cornflowerblue' and so on and you'll get back the #aaa form of the color.
>> each status has an individual color
so you want to set this on a cell-by-cell basis. So for the column, go to the CSS tab.
There in "additional CSS properties" you can set;
Css Property: background-color
Value: Cus:Color
(the call to ColorToWeb will be done for you.)
cheers
Bruce