Conditional Formatting

[Sammie516]

Hi,

I need help with conditional formatting of two sheets. 

Using Example 2 sheet - find the order #(column A) and order total (column J) on Example 1 sheet - if its a match color both lines GREEN on both sheets

Using Example 2 sheet find the order # and order total on Example 1 sheet - if the order # is the same and order total is different color both lines YELLOW on both sheets

Using Example 2 sheet find the order # and order total on Example 1 sheet - if neither is there color both line RED on both sheets

I have attached the excel spreadsheet for reference.

Thanks!

[#2 · Accepted solution]

@Sammie516 

You can try the attached file. Maybe this is what you are looking for.

[#3]

Thanks!