Saturday, February 21, 2015

Excel Conditional formatting if in list

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

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...