I have a conditional formatting rule set to highlight a cell if certain keywords are present in the text of the cell using this formula:
=SUMPRODUCT(IFERROR(FIND(A4:A100,C5),0))>0
where A4:A100 is a list of keywords.
This is working but the problem is the list keywords needs to be able to be edited/added or deleted to and from. So when any of the cells in A4:A100 are empty, it results in the targeted cell also being highlighted if C5 is empty, which is an undesired effect. Is there any way to set the conditional formatting to ignore the blank cells in the A4:A100 range?
Bookmarks