Conditional formatting - using 2 fields
I'm trying to set up an "alert" that would require the formatting of one cell to be dependent on the value of a different cell (in the same table).
Specifically, I have data for schedules and data for contract payments. I would like to automatically highlight a cell in the schedule when a value is detected in a corresponding cell in the contract payments.
Is there a way to link cells so that they can be conditionally formatted this way?