Conditional format rule to highlight cell in array based on containing text from another worksheet

Copper Contributor

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 attached a workbook, which contains a dashboard view of the application names which are in a wave. I want to highlight these names ONLY if their domain does NOT contain "google.com" at the end of the FQDN Column in the "Dataset" sheet.

ConnorAlign_0-1716398401747.png

 

You can see I manually highlight red w/ white text to show what I mean. However, the conditional format rule only has to apply to the dashboard.

 

Thanks!

 

1 Reply

Hi @ConnorAlign 

 

I get the following that IMHO matches what you described (so slightly different than what you manually colored):

Sample.png

 

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))