Analyze_This
Board Regular
- Joined
- Oct 29, 2008
- Messages
- 122
Here's my problem. I need to write a conditional formatting equation that will highlight the cell if it is equal to the contents of either D16, G16, J16, or M15.
If ANY of those cells share the same value as my activecell, I'd need it to return true and format the activecell. I've tried several methods using OR( but none of them seem to work. Any ideas?
If ANY of those cells share the same value as my activecell, I'd need it to return true and format the activecell. I've tried several methods using OR( but none of them seem to work. Any ideas?