I needed to check which indexes exist on another sheet.
So for the
A:A range, I made conditional formatting with the following formula:
That had a red error outline.
Then I filled column
='Other Sheet'!A:A and used the formula
It worked instantly.
What am I doing wrong?