Hi,

I am trying to apply conditional formatting in order to compare two
identical tables to track changes that will be made to one of them. I
have followed the steps provided on this website,
http://j-walk.com/ss/excel/usertips/tip073.htm, but this only works
for the text that is in my tables and not for the numerical values,
although it is specified that this formula should work for both
numbers and text. Can you please help. I am not sure what I am doing
wrong. I have followed the instructions step-by-step!

I have provided below an example of my table, any of these numbers or
text can be changed.

0 0 0 1 1.5 36 0 response received
0 0 0 0 0 0 0 response pending


Thanks!