ksjohnson86
New Member
- Joined
- Aug 10, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
I have a range of cells that currently are conditionally formatted to turn any cells within the same row yellow with dark yellow text if they have duplicate values. However, I also want them to turn yellow if they have matching strings of text. Specifically, each cell can have a single number value, or it can contain a string of numbers formatted as "/x/y/z/". For example, cell B2 might have "12" and cell D2 might have "/4/22/12/16/".
I've successfully used the SEARCH function to capture these "/x/" strings for other tracking functions in this workbook. But the problem is when I try to use it in a formula for conditional formatting and apply it to an array of cells, I inevitably end up self-referencing and I get an error message. Any ideas for accomplishing this using VBA? Or a formula to use in conditional formatting that doesn't end up self-referential?
Thanks!
I've successfully used the SEARCH function to capture these "/x/" strings for other tracking functions in this workbook. But the problem is when I try to use it in a formula for conditional formatting and apply it to an array of cells, I inevitably end up self-referencing and I get an error message. Any ideas for accomplishing this using VBA? Or a formula to use in conditional formatting that doesn't end up self-referential?
Thanks!