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 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.