Conditional Formatting Formula - vlookup and compare?

New Contributor

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 column J the cell shades red.

 

Is this possible? 

3 Replies

Hi Denise

 

You may apply the rule

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

to Sheet2!J:J

 

That worked!!! Thank you.

You may need to use a formula like this if your data is not exactly sorted in the identical order - this applies to cell A2 of Sheet1: use this formula and select red fill.

 

=IFERROR(J2>VLOOKUP(A2,Sheet2!A:J,10,FALSE),FALSE)

 

www.000webhost.com