I have a list of values J1:J100 and another list of values E1:E75
If a cell in column J matches a cell in column E, I would like this cell to be highlighted.
Any ideas what formula to enter into the conditional formatting prompt for Excel? I'm not too sure of syntax for conditional formatting.
I've found this online:
http://www.ozgrid.com/forum/showthread.php?t=149496
And tried to tweak it but to little avail.
No comments:
Post a Comment