(Solved) – Work Around to Conditional Formatting Between 2 Workbooks

  • by

I am trying to link two workbooks using an IF statement. It would be best if I could use Conditional Formatting since I want two conditions for the same cells but, since that is not possible (I have not found anything at least) I have decided to put the formula in the cells.

The formula

=IF(AND(D2 = '[Turn Keys 2020.xlsx]Sheet1'!$D$2, E2 = '[Turn Keys 2020.xlsx]Sheet1'!$E$2), "Renewal")

works but, when I drag it down the rest of the column the data from the 2nd workbook does not update. Is there a fix to this?

Leave a Reply

Your email address will not be published. Required fields are marked *