I have compared two dataframes to get the difference, with respect cell value mismatched and missing rows, either in Source Dataframe or Target.
I want to highlight difference in cell value, using background color. And if there are rows missing in either source or target dataframe, the highlight the entire row as shown below
differece between 2 dataframes
- row 5 is missing in target df, should be highlighted in navy blue
- color row 2985 missing in source df, to be highlighted in green.
- any mismatched cell value in some different color
I would really appreciate any help