Forum Discussion
Denise Stewart
Oct 18, 2017Copper Contributor
Conditional Formatting Formula - vlookup and compare?
I need a conditional formatting formula that will give me the following: If data in sheet1 column A matches the data in sheet2 column A and the date in sheet1 column J is greater than sheet2 colu...
SergeiBaklan
Oct 18, 2017Diamond Contributor
Hi Denise
You may apply the rule
=(Sheet1!$A1=Sheet2!$A1)*(Sheet1!$J1>Sheet2!$J1)
to Sheet2!J:J
- Denise StewartOct 18, 2017Copper ContributorThat worked!!! Thank you.