Applying direct formatting to spilled arrays in Excel could cause issues ... Since the ISTEXT function treats blank cells and cells containing text as a text value, the conditional formatting ...

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...