Skip to main content

Hi,

I'm working on a formula, which ideally I would like for to output color in its respective field.

IF (BSC_Last_12_Months__c > 30000,"Platinum",

IF(BSC_Last_12_Months__c > 15000,"Gold",

IF(BSC_Last_12_Months__c > 2500,"Silver",

IF(BSC_Last_12_Months__c > 0,"Bronze",NULL))))

I have the hex codes for the colors I need:

#e5e4e2

Plat

#ffd700

Gold

#c0c0c0

Silver

But, can't seem to make it stick. I've seen also other posts suggesting that I use image/files/servlets? No idea where I can get those.

Any help would be greatly appreciated.

Thank you!

Orquidea

10 comments
0/9000