Oct 18 2017
07:46 AM
 last edited on
Jul 25 2018
10:14 AM
by
TechCommunityAP
 Mark as New
 Bookmark
 Subscribe
 Mute
 Subscribe to RSS Feed
 Permalink
 Email to a Friend
 Report Inappropriate Content
Oct 18 2017
07:46 AM
 last edited on
Jul 25 2018
10:14 AM
by
TechCommunityAP
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?
 Labels:

Formulas & Functions

Need Help
 Mark as New
 Bookmark
 Subscribe
 Mute
 Subscribe to RSS Feed
 Permalink
 Email to a Friend
 Report Inappropriate Content
Oct 18 2017 07:51 AM
Hi Denise
You may apply the rule
=(Sheet1!$A1=Sheet2!$A1)*(Sheet1!$J1>Sheet2!$J1)
to Sheet2!J:J
 Mark as New
 Bookmark
 Subscribe
 Mute
 Subscribe to RSS Feed
 Permalink
 Email to a Friend
 Report Inappropriate Content
Oct 18 2017 08:34 AM
 Mark as New
 Bookmark
 Subscribe
 Mute
 Subscribe to RSS Feed
 Permalink
 Email to a Friend
 Report Inappropriate Content
Oct 18 2017 10:10 AM
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)