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?
1Welcome to Web Applications Stack Exchange. Consider sharing a publicly editable sample spreadsheet with realistic-looking data.– doubleunaryNov 10, 2021 at 22:02
Try a conditional formatting custom formula rule that uses indirect() to reference the cell on another sheet.