Forum Discussion
Formatting depending upon results form a vstack
I have a dynamic VSTACK being displayed. I want to format an adjacent cell in each line of the VSTACK with a boarder that appears or disappears according to changing number of rows in the VSTACK. ...
Hello The-WOD,
You can use Conditional Formatting to show a border beside each row returned by your VSTACK formula.
Select the adjacent cells you want to format. Go to Home > Conditional Formatting > New Rule and choose the option to use a formula.
If your VSTACK results start in A2, use:
=A2<>""
Choose Format, then Border, and select the border you want. Set Applies to the adjacent cell range you want to format.
The border will appear when the corresponding cell in column A is not blank and disappear when it becomes blank.
If your VSTACK returns empty strings or includes blank rows, the rule may need to be adjusted. Sharing your VSTACK formula and the locations of the results and adjacent cells would help identify the correct formula.