Forum Discussion

Denise Stewart's avatar
Denise Stewart
Copper Contributor
Oct 18, 2017

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...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 18, 2017

Hi Denise

 

You may apply the rule

=(Sheet1!$A1=Sheet2!$A1)*(Sheet1!$J1>Sheet2!$J1)

to Sheet2!J:J

 

  • Denise Stewart's avatar
    Denise Stewart
    Copper Contributor
    Oct 18, 2017
    That worked!!! Thank you.