I need a conditional formatting formula
Posted on 2014-03-26
I am trying to compare dates between two diff workbooks, workbooks New & Old.
I want a conditional formatting formula to look at the Old Sheet in A1 and compare it in the new sheet A1. If its the same date, nothing. If its a different date, then it turns red.
I am not limiting myself to the conditional formatting formula. If anyone else has ideas, feel free to post them.
I thought about linking to the old sheet on the new sheet, like AA1 and buld a formula there to return True / False comparing the two cell values. Then base my conditional formatting on that.