4 Replies Latest reply on Feb 24, 2011 11:42 AM by AiahWieder

    Conditional formatting - using 2 fields



      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?