Conditional formatting from another google sheet

Question

I am trying to create a conditional format for a cell to turn red, if that value is less than the value of another cell on a separate sheet. Does anybody know how to do this?

Answer 1

Try a conditional formatting custom formula rule that uses indirect() to reference the cell on another sheet.