AnsweredAssumed Answered

Conditional formatting - using 2 fields

Question asked by AiahWieder on Feb 24, 2011
Latest reply on Feb 24, 2011 by AiahWieder


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?