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.

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!

​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. 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!   Read More

​