Compare two data in excel and highligh the difference in colors

[nayrah]

i would like to compare two data in excel and highlight the differences in colors

Example attached here for your kind review

Kindly see experts advise on this topic

thanks 

[gawa · Accepted solution]

hi @nayrah 

Reporting tool should be used for coloring. Here is the example of using Table tool.

[nayrah]

Thank you so much gawa, really appreciated for your time

[rzdodson]

@nayrah if the above provided a solution to your use case, please accept @gawa's post as a solution so others can find an answer to their future queries a little easier. :)