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?
1 Answer
Try a conditional formatting custom formula rule that uses indirect() to reference the cell on another sheet.