A list of colors for crystal?

[cjbrown815]

Hello,
I'm looking for more font colors in crystal.

crYellow needs to be maybe crGold? Where can I find a list of options?

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

If you go into any color formatting formula area, it will show you the options commented out, or you can look in the function list at the top. In addition to standard colors, you can create your own using rgb(,,) where you enter a value from 0 to 250 (if I remember correctly) for each of the red, green, and blue values.

-LB

 

[cjbrown815]

So in the formula below, how would I incorprate the rgb(,,)?
Thanks

if {#Mold} = "TNTC" then crRed else
if {#Mold} = "NR" then crBlue else
if {#Mold} = "<1" then crGreen else
if {#Mold} = ">150" then crRed else
if totext(val({#Mold}),"000") in "000" to "005" then
crGreen else
if totext(val({#Mold}),"000") in "006" to "009" then
crYellow else
if totext(val({#Mold}),"000") > "009" then
crRed else
crNoColor

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

if {#Mold} = "TNTC" then rgb(100,100,200) else //etc.

Or you can use color(100,100,200)//etc.

You'll have to experiment with the values.

-LB

 

[cjbrown815]

thank you

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931