+ Start a Discussion
AK Singh 1AK Singh 1 

Want to highlight ETA field with specific color on list view when ETA field is updated once and if field updated twice than it should be highlighted with another color

Hi,
My requirement is to get below color indicators on an field-
  • ETA Changed 1st Time – Green 
  • ETA Changed 2nd Time – Yellow
Anybody please assist 
Dhanya NDhanya N
Hi AK Singh,

I don't think if we can change the color of field value. You need to find some workaround to achieve this.

What you can do here is you can create a formula field to display some color flag. Something like in this blog https://blog.ijasoneverett.com/2017/08/adding-custom-color-flag-fields-in-salesforce/

To track the number of times ETA field is changed, create a number field 'ETA change count' which is hidden from page layout. Update this field with increment from workflow rule whenever ETA field is changed.

Then in formula field, based on 'ETA changed count' show color flag. 
IF( ETA_changed_count__c = 1, IMAGE("/img/samples/flag_green.gif", 'Green') , IF(ETA_changed_count__c > 1, IMAGE("/img/samples/flag_yellow.gif", 'Yellow'), '') )
Let me know if you have any question on this.

Thanks,
Dhanya