Conditionally formatting empty .lookup() rows

I have a column that does a lookup from another table, if there’s no record and the cell is empty, how can I target these empty look up rows since .isBlank() doesn’t match these empty lookup columns?

as you can see conditionally formatting isn’t matching on the 4 rows above, 2 empty and 2 empty arrays(due to missing a task to pull a status from)


Lookup() returns a list of rows.

One approach might be a conditional formatting rule that’s something like this: status.Count() < 1


ah good shout! Thank you very much for the help! :slight_smile: