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:
#e5e4e2Plat
#ffd700Gold
#c0c0c0Silver
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