How do I get custom formula conditional formulas to apply to Array results?

0
votes

I need to apply conditional formatting to results of an array formula to highlight any result that has the word "Installation" in it.

I have a calendar with Array formula results. I want to highlight anything that contains the word INSTALLATION in the block.

I have used the conditional formatting custom formula of =find("Installation",$C$2:$G:$55) but, even though the array formula results contain Installation, the formatting is not applied.

Below is my sheet. Thanks in advance.

https://docs.google.com/spreadsheets/d/1noCiboVB5_yTq9H0W_-q9goqc4E9Gq0DhcNMuXj9Kz4/edit#gid=286793601

1
array-formulasgoogle-sheets-formulags-conditional-formatting
We can't access your sheet. Please change sharing settings. – Florian Minges

1 Answers

0
votes

You don't actually need to use a custom formula for this. Conditional Formatting has an in-built function to check if the text contains a certain string.

enter image description here

This formula works, but you have to make sure that it takes precedence over your basic formula which colours cells green if they have any type of content. Basically, drag it on top of the list of active conditional formatting rules for your cells.

enter image description here