How do I get custom formula conditional formulas to apply to Array results?
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.
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.
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.
- Google Sheet Vlookup Multiple Criteria
- OR function not working with arrayformula in Google Sheets
- How to count a specific word from a string in a cell from the entire column in google sheets
- Google Sheets ARRAYFORMULA with Partial Match and Multiple Criteria Not Returning Expected Results
- How do I set up a formula that matches columns between two sheets, while returning blank values for the first two rows regardless of values
- How to update excel formula to work for all columns continuously to the right and not just the current 2 it's set up for
- Formula not working when parsing set a dynamic range in Google spreadsheet formula ARRAYFORMULA
- Combine two columns that's are on a column "B" and column "C" and then make them into one column on column "E" with even and odd position each others
- Arrayformula with Query in Google Sheets
- What is an equivalent for INDEX in ARRAYFORMULA?
- Find the position of a cell by sub-string based on another range in an array (Google Sheets formula)
- Collapsing Wide Data into Tall Data in Google Sheets
- Remove diacritics via formula on Google Sheets (Part 2)
- Get the exact value in array
- Find Latest Revision and Return Hyperlink using a Column to Search
- How to set cell color based in duplicated value in column with different colours for each values
- Arrayformula with IFS function didn't expand the output result in a column
- Getting the count and unique values of a column of comma separated values?
- Copy value from a cell to the rest of a colum
- Google Sheets - Difference of Two Columns With Duplicate Values
- I have a problem with removed records in Excel using Openpyxl
- Using arrayformula to add suffix, but would like to skip empty cells
- Arrayformula to SUM matching ID AND when date is between two dates
- How to use arrayformula with a query that groups and sums a certain column in googlesheets
- How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?
- ARRAYFORMULA option for checking for cell values on each row of Google Sheet
- How do I use INDIRECT inside an Excel array formula?
- I have a dataset of team members reserving one ( or more) of five rooms. I need a function that can populate a Schedule Sheet dynamically
- I want to automatically populate a calendar sheet with scheduled meetings as team members select dates for events/meetings on different sheet
- Google Sheets Query - build referenced array source dynamically