Hi All
I have few records which are getting updated in the source data and I need to highlight them,based on the trend.In other words, in this case, if an employee's designation changes(they get promoted), then that change will be highlighted as (RED in this case) and other details like CONTACT should be highlighted in some other different color(Green here).
Usage of Conditional formatting or Alerters don't have that provision( I mean all we could do is to select a specific field and control the display via relational operators alone. Please help me achieving this:-
The First One is before change and Second one is after change.