Countblank and ImportRange for Conditional Formatting Custom Function

1
votes

So I am trying to set up a conditional formatting custom function that will highlight the cell in question if a certain range on another spreadsheet contains any blank cells up to the last row of that spreadsheet. Can I write this as a formula for conditional formatting? Any help would be appreciated, thank you.

I tried:

=IF(COUNTBLANK(IMPORTRANGE(Index!$C9,"report.csv!E:F")))>0
1
if-statementgoogle-sheetsreferencegoogle-sheets-formulags-conditional-formatting

1 Answers

0
votes

when referencing another sheet in conditional formatting you need to use INDIRECT()

try:

=IF(COUNTBLANK(IMPORTRANGE(INDIRECT("Index!$C9"), "report.csv!E:F"))>0, 1)