Forum Discussion
ConnorAlign
May 22, 2024Copper Contributor
Conditional format rule to highlight cell in array based on containing text from another worksheet
Hi, I am looking for a conditional format rule which I can highlight specific cells in an array based on a cell in another worksheet that does NOT contain "google.com" in the FQDN. I've atta...
Lorenzo
May 22, 2024Silver Contributor
Hi ConnorAlign
I get the following that IMHO matches what you described (so slightly different than what you manually colored):
See
- [HELPER] column (can be hidden) in sheet 'Dataset' + Defined Name 'MasterServerToApp_HELPER' in Name Manager
- Cond. Format. rule that applies to $B$7:$D$87 is:
=SUM(--(MasterServerToApp_HELPER=B$4&"|"&B7))