Conditional Formatting from another sheet

For some reason (I confess I don’t really know why) a custom formula in conditional formatting does not directly support cross-sheet references.

But cross-sheet references are supported INDIRECT-ly:

=A1>INDIRECT("SheetB!A1")

or if you want to compare A1:B10 on SheetA with A1:B10 on SheetB, then use:

=A1>INDIRECT("SheetB!A1:B10")

=A1>INDIRECT("SheetB!"&CELL("address",A1))

applied to range A1:B10.

Related Posts:

  1. How do I filter view two columns OR instead of AND?
  2. Add a “sort” to a =QUERY statement in Google Spreadsheets
  3. Excel to Google Sheets – Error: Formula parse error
  4. How to use searchFile and searchFolder at the same time correctly? – App Script
  5. How to define global variable in Google Apps Script
  6. Google Spreadsheet adding tooltip
  7. How to label scatterplot points by name?

Leave a Comment

techhipbettruvabetnorabahisbahis forumueduedueduedueduseduedueduseduedus